View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
user user is offline
external usenet poster
 
Posts: 44
Default PT Sum of Difference

Hello

I have 2 columns with data. I want to create a Pivot table which shows me
the sum of column A and column B by month, and I want a 3rd column showing
the difference between the col. A&B. I created a sum of col A, sum of col B,
then added col B again, click Field Setting and choose show data as:
Difference From, in base field, choose col B, and base item, chose
(previous). But, it's not working and giving me #n/a. i tried to flip it,
but nothing seems to be working.

Please help!
--
Thanks