Calculated field in pivot table

  • Thread starter Thread starter Tommy
  • Start date Start date
T

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!!
 
Back
Top