Thanks Debra. Only question remains is how do I bring that info back into
report and still allow the data to change with different pivot table
selections, ie., brand, store, category...

"Debra Dalgleish" wrote:

A calculated item will use the Normal summary function, e.g. Sum, from
the other columns, not the custom calculation, like Running Total, if shown.

You could calculate the difference outside the pivot table.

David D wrote:
I have built a pivot table that contains rolling totals. When I try and get a
% change between two (2) rolling total columns, the data does not calculate
correctly. I am certain that the formula used is correct. Is there an issue
with excel that does not allow two calculated columns to be used in the
calculation of a third?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html