ssalazarjr
Board Regular
- Joined
- Jun 1, 2009
- Messages
- 158
I have a spread sheet of individual sales/returns. The sales show as a positive dollar amount. The returns show as a negative dollar amount.
Summing them gives me the correct dollar amount.
But counting them is giving me the incorrect amount.
For example:
40
20
-20
10
should give me a count of 2 because the sale then return count as 0. But I get a count of 4 because its counting every number.
Any ideas how to fix this in a Pivot Table?
Summing them gives me the correct dollar amount.
But counting them is giving me the incorrect amount.
For example:
40
20
-20
10
should give me a count of 2 because the sale then return count as 0. But I get a count of 4 because its counting every number.
Any ideas how to fix this in a Pivot Table?