Pivot Table Formula Help

[sdallen24]

My basic data is in this format

Store Year Count
1 2000 15
1 2001 20
2 2000 15
2 2001 12
3 2000 11
3 2001 19
4 2000 18
4 2001 17

For each store I want to calculate the difference in count between years. I realize if the count was a value in a year column, this is easy. Is it possible to calculate a pivot table formula based on the values of a field (i.e. year)?

 

[Robert Mika]

Hi sdallen and wecome to the bpard.
If that wil be any help for you
After creating your pivot table click Right button on a cell within it ad go to
"Show Values as..."-->"Difference from"