Suppose
I have in 3 columns and 3 rows:
Money 25 30
HK -45 2
EQ 3 -4
Can I use a pivot table to sum only the positive number such that the output would be :
Money 55
HK 2
EQ 3
Thanks very much, oh pls give a bit more guidance on what button to click under pivot table...
I have in 3 columns and 3 rows:
Money 25 30
HK -45 2
EQ 3 -4
Can I use a pivot table to sum only the positive number such that the output would be :
Money 55
HK 2
EQ 3
Thanks very much, oh pls give a bit more guidance on what button to click under pivot table...