Pivot Table Sum Positive And Negative Numbers Regardless Of Sign in Row Lable

[ThrottleWorks]

Hi,


Is there any way to display Pivot Table Sum in total numbers regardless of Positive And Negative Numbers in Row Label.


For example I have numbers as 100, 200, -300, my pivot table should should show the sum as 600 instead of 0. Is it possibele ?


I cannot chnange the original data.


Can anyone help me in this please.

 

[Hui]

Why not add a Calculated Field using a formula =ABS(Existing field)

Then use the calculated field instead of the original field in the PT


You can read more about Calculated Fields here:

http://chandoo.org/wp/2010/02/25/p-l-reports-calculated-fields-3/

&

http://chandoo.org/wp/2010/01/27/pivot-table-tricks/

 

[ThrottleWorks]

Hi Hui Sir, thanks a lot for your reply & valuable time, I will try this.


Extreamally sorry for late reply, have a nice day.