Difference Between two columns in Pivort Table

[krishna20]

Hi Friends,

I need to find the difference between two columns in pivort table.

My requirement is like

Year                     2014                                                     2013                                     2014 -2013

Product     

               Payment             Recovery                 Payment         Recovery            Payment           Recovery

A                100                        200                     150                      120                  -20                         80

B                 200                         50                       100                     100                  100                       -50

C                 400                        200                      100                       200                 300                       0

How can we achieve this year's column difference.Please any one can suggest me.

Regards

Krishna

[alexandros17]

Unfortunatly you cannot have a total value without partial values (this means you cannot hide the columns in red)

[francoiscave]

Hi Krishna,

Have you find a solution ?

If your are satisfied by a response, please mark it as correct or helpful to close this tread.

If not, how can we help you?

Thanks,

François