V
Valeri
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.
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.