How to convert the count of number into sum of number in piot table

[pramod suvarna]

Hi all,

in a piot table how to convert the multiple column count of number into sum of number .

thank you.

 

[CWatts]

Where it says "Count of Number" either in your pivot wizard or your field list (depending on your excel version) click it, and go to value field settings and select "Sum of Number" in the list.