Calculation based on running total in Pivot table
Posted by G Patterson on February 04, 2001 5:44 PM
To illustrate my problem:
Col_A 14 15
Col_B 20 25
Col_C 20 45 (running total of Col_B)
Col_D 70% 33%(Col_A/Col_C)
Col_C must be calculated in the pivot table.
I can get Col_C to be displayed as a running total,
but the underlying field still contains the individual
numbers. This results in Col_D dividing by the same
value as Col_B, not the running total number from Col_C.