I have a question on excel pivot table.
Here is my data set
Company profit
A 1
A 1
A -1
A -2
A 3
B 1
B 1
B 1
C -2
The pivot table I need is as follows:
Positive
A: 1
B: 3
Negative
C: -2
The pivot table I can get is
Positive
A: 4
B: 3
Negative
A: -3
C: -2
How do I net company A in pivot table?
Thanks a million!
