Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculated Fields and Pivot Tables
Assume that I have a Pivot Table that looks as follows:
Jan-08 Feb-08 Mar-08 Apr-08 Total Client 1 10,000 11,000 8,000 14,000 43,000 Client 2 0 2,000 500 100 2,600 Client 3 5,000 4,500 0 0 9,500 Client 4 15,000 15,000 13,000 8,000 51,000 Client 5 3,500 5,000 7,500 9,000 25,000 33,500 37,500 29,000 31,100 131,100 I would like to have the Pivot table to produce results like this: Jan-08 Feb-08 Mar-08 Apr-08 Total Client 1 10,000 11,000 8,000 14,000 43,000 % of Prior Month 110.00% 72.73% 175.00% % of Current Month 29.33% 27.59% 45.02% Client 2 0 2,000 500 100 2,600 % of Prior Month #DIV/0! 25.00% 20.00% % of Current Month 5.33% 1.72% 0.32% Client 3 5,000 4,500 0 0 9,500 % of Prior Month 90.00% 0.00% #DIV/0! % of Current Month 12.00% 0.00% 0.00% Client 4 15,000 15,000 13,000 8,000 51,000 % of Prior Month 100.00% 86.67% 61.54% % of Current Month 40.00% 44.83% 25.72% Client 5 3,500 5,000 7,500 9,000 25,000 % of Prior Month 142.86% 150.00% 120.00% % of Current Month 13.33% 25.86% 28.94% 33,500 37,500 29,000 31,100 131,100 For Client 2 for Feb-08 the % of Prior Month should be 100%. For Client 3 for Apr-08 the % of Prior Month should be 0%. I don't know how to get the new rows to calculate inside the pivot table. I think that Calculated Fields would be used but I can't seem to figure how to do it after reading some books that I have. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculated Fields and Pivot Tables
This calculates % of prior month.
No Calculated Field or formula needed. http://www.savefile.com/files/1545247 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables - how do I add in calculated fields? | Excel Worksheet Functions | |||
Calculated Fields in Pivot Tables | Excel Worksheet Functions | |||
Calculated fields in pivot tables | Excel Worksheet Functions | |||
Pivot tables - calculated fields | Excel Worksheet Functions | |||
Pivot Tables, calculated fields | Excel Discussion (Misc queries) |