Forum Discussion
SUBTRACTION IN PIVOT TABLE
Dear Member,
I have created pivot table using existing data. Now there is two different type of data I need to comapre. data A vs Data B. In data A , there is two different value in data A called value 1 and Value 2. and Value 3 & Value 4 in data B. Now using pivot table I want to compare sum of Value 1 of data A vs Sum of Value 3 of data B. And same sum of Value 2 in data A vs sum of Value 4 in data b and in last where generally we get sum of VALUE 1 & 3 and Value 2 & 4 , I need to subtract this value so I can find difference.
Thank you
2 Replies
i am not quite sure. You can create 2 different Pivot Tables with Filters for Data A and B.
or try to use Calculations group..
Can you post a Screenshot of an Example here to understand it better`?
Could you please explain on the simple sample what exactly do you mean. It's not clear, in particular, what are Data A and Data B - data sources, fields, PivotTables, etc.
Plus on which Excel platform you are.
