Get instant live Excel expert help with Pivot Tables

how to make pivot table in excel that is compatible with the existing table?

In Excel for Mac how do I build a pivot table from multiple ranges

iam trying to enter a calculation to determine the difference in time between two event types in a pivot table

Hi I have an excel spreadsheet which I am looking to get modified. . At the minute there is 1no pivot table page and one report page. I am looking to add on extra sheets. With the same formula and on the pitot table I’m looking to add on extra columns which are the sum of profits and above it will be sheet 1 sheet 2 sheets 3. The box on the right will stay the same as it will add up all the results of all the sheets month by month. So basically the pivot table stays much the same except there will be and extra columns for sum of profits for each sheet. I may have up to a total of 30 sheets open so will need 30no columns with sum of profits.

spreadsheet which I am looking to get modified. I use it for Fx trading and looking at returns of each currency pair.. I am looking to add on extra sheets With the same formula and on the pitot table I’m looking to add on extra columns which are the sum of profits and above it will be sheet 1, 2 and 3. So basically the pivot table stays much the same except there will be and extra columns for sum of profits for each sheet. I may have up to a total of 30 sheets open so will need 30no columns with sum of profits. Also when I adjust the numbers in the report it doesn’t adjust the figures in the pivot table.

My Pivot table is grayed out on Excel and I cannot open it to modify it

I am needing help modifying my Pivot table. I have a Pivot table but I cannot open the Pivot table options.

I am trying to create an "Average" field to calculate the average of multiple columns in a pivot table (each column separately that is) knowing that the rows under each column will change according to slicer selection. I was able to create the formula to calculate that but i just noticed that once the reference word in my formula (which is "grand total") falls after row 99 then the formula gives no results !! here is the formula =IFERROR(AVERAGEIF(INDIRECT(B10&"15:"&B10&RIGHT(CELL("address",INDEX($A$13:$W$101,MATCH("Grand Total",$A$13:$A$101,0),1)),2)-1),"<>0"),"") any suggestion?

Need to generate a report that compares the company's performance in 2016 vs 2017.maybe using a pivot table and some graphical representation , eg graph etc

I have a sales report for multiple sales reps, I extract the data monthly from server, then I filter and then I separate into multiple workbooks then I create a pivot table for each workbook and then I dump that data into my quota tracker. Need a code that will automatically distribute the data to each workbook and run the pivot table, can that be done and how much will it cost?