Re: Calculated field in pivot table

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

Tommy wrote:

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
.

Relevant Pages

  • Re: Calculated field in pivot table
    ... Sum of QTY LOCATION ... ITEM STORE-A STORE-B ... The question is I want to make a "calculated field" in the pivot table to ...
    (microsoft.public.excel)
  • Calculated field in pivot table
    ... Sum of QTY LOCATION ... ITEM STORE-A STORE-B ... The question is I want to make a "calculated field" in the pivot table to ...
    (microsoft.public.excel)