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. |
All times are GMT +1. The time now is 08:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com