Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Tables
Can someone tell me if you can do a Pivot table using the results of another
Pivot table? I need to do this because in one rollup, I need to find a MAX value. Then, I need to do a SUM operation. I do not seem to be able to do this is the same Pivot table. Thanks in advance. -- DM |
#2
|
|||
|
|||
Hi Dave,
There may be a better way of doing this, but I did it quite simply as follows: Create a new pivot table, and rather than select "Another Pivot Table", select "Microsoft Excel List or Database". Now simply select the cells that your other pivot table reside in as your data source. Given that your pivot table may change in size on a refresh, you can create a dynamic named range using an offset formula and then base the new pivot table on this. The formula I used for the named range was this: =OFFSET(Annual!$A$4,,,COUNTA(Annual!$B:$B)-2,COUNTA(Annual!$4:$4)) There may be something you can do with the GetPivotData formula. Let me know if you need further help. Baz "Dave" wrote: Can someone tell me if you can do a Pivot table using the results of another Pivot table? I need to do this because in one rollup, I need to find a MAX value. Then, I need to do a SUM operation. I do not seem to be able to do this is the same Pivot table. Thanks in advance. -- DM |
#3
|
|||
|
|||
I've always copied and pasted the pivot as text and then done a pivot table
off this data. If someone has a better solution, I'd love to hear it. -- David Ruderman Director of Marketing Chapman University "Dave" wrote: Can someone tell me if you can do a Pivot table using the results of another Pivot table? I need to do this because in one rollup, I need to find a MAX value. Then, I need to do a SUM operation. I do not seem to be able to do this is the same Pivot table. Thanks in advance. -- DM |
#4
|
|||
|
|||
Look at my previous post. That way you wouldn't need to paste a duplicate of
the data, and if the base pivot changes, all changes will be updated in the source of the second pivot (using the dynamic named range). Try it! "David Ruderman - Chapman University" wrote: I've always copied and pasted the pivot as text and then done a pivot table off this data. If someone has a better solution, I'd love to hear it. -- David Ruderman Director of Marketing Chapman University "Dave" wrote: Can someone tell me if you can do a Pivot table using the results of another Pivot table? I need to do this because in one rollup, I need to find a MAX value. Then, I need to do a SUM operation. I do not seem to be able to do this is the same Pivot table. Thanks in advance. -- DM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |