Calculated field in pivot table

[Tommy]

Hi I have a data source like this

ITEM QTY LOCATION
GGG 1,500 STORE-A
GGG 1,200 STORE-B
TTT 37,000 STORE-A
TTT 39,000 STORE-B


and futher make a pivot table like this

Sum of QTY LOCATION
ITEM STORE-A STORE-B
GGG 1,500 1,200
TTT 37,000 39,000
Grand Total 38,500 40,200


The question is I want to make a "calculated field" in the pivot table to
make the diff like

Sum of QTY LOCATION
ITEM STORE-A STORE-B DIFF
GGG 1,500 1,200 -300
TTT 37,000 39,000 2,000
Grand Total 38,500 40,200 1,700


Is that possible to do so?

Thank you!!

 

[Dave Peterson]

Take a look at Debra Dalgleish's site:
http://contextures.com/xlPivot10.html

 

[Tommy]

I got it, thank you!!

Take a look at Debra Dalgleish's site:
http://contextures.com/xlPivot10.html