Hi,
I would like to tailor a field in a pivot table to count all of the values that are above 0. At the moment when I use the count function it returns the total of every single entry however I want it to count just those with a value over 0.
I have been using the calculated field section but it is not working for me:
=MASF >0 and it sums rather than counts.
Please help. Thank you
Ginny
I would like to tailor a field in a pivot table to count all of the values that are above 0. At the moment when I use the count function it returns the total of every single entry however I want it to count just those with a value over 0.
I have been using the calculated field section but it is not working for me:
=MASF >0 and it sums rather than counts.
Please help. Thank you
Ginny