Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table, Calculated Field, Running Total
Hi,
I have the following pivot table: Week Delivery Space Utilization Week1 42.3 200.4 21.1% Week2 24.5 50.3 48.7% Week3 39.6 135.3 29.5% Total 106.4 386.0 27.56% The Utilization field is a calculated field = Delivery/Space. What I need is to keep week-to-date running totals, so the utilization column would have 21.1%, 26.7% and 27.6% (Week2 = (42.3+24.5)/(200.4+50.3), Week3=(42.3+24.5+39.6)/(200.4+50.3+135.3)....) Is there any way to do it within the pivot table, without having an adjacent calculated field (the actual pivot table is more complex and might have a floating number of fields)? I experimented with the "running total in" option for the Week field but all it adds percentages from the previous and current week, so it shows something like 21%,69.8%,100%. TIA. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Calculated Field using Grand Total | Excel Worksheet Functions | |||
Incorrect total of calculated field in pivot table | Excel Discussion (Misc queries) | |||
Using '% of Total' in calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
Missing Grand Total for a Calculated Field in a Pivot Table | Excel Worksheet Functions | |||
Pivot Table Calculated Field (Grand total question) | Excel Discussion (Misc queries) |