I already know how to create the Running Totals in a Pivot Table.
I am asking how to make a calculated field from those two Running
Totals without having to resort to a helper column outside the Pivot
Table.
hi, Chris !
> I already know how to create the Running Totals in a Pivot Table.
> I am asking how to make a calculated field from those two Running
> Totals without having to resort to a helper column outside the Pivot Table.
you never "show" to us how your PT layout looks-like (so, just in case)...
if you have only 2 "data-items" in a "2 rows arrangement" PT -?-
be sure your PT layout is (or can be) accomodated like this one:
-> Excel - Pivot Tables - Data Field Layout
http://www.contextures.com/xlPivot02.html
now, you will be able to add/formulate/... your custom calculated field
if any doubts (or further information)... would you please comment ?
regards,
hector.