J
Jenzz22
So for this example data:
a b
1. 4 Red
2. 6 blue
3. 5 green
4. 8 yellow
I want the output to be -
Red 4
Blue 6
Green 5
Yellow 8
Red + Blue - 10
Is there a way to do this in a pivot table?
Thanks
a b
1. 4 Red
2. 6 blue
3. 5 green
4. 8 yellow
I want the output to be -
Red 4
Blue 6
Green 5
Yellow 8
Red + Blue - 10
Is there a way to do this in a pivot table?
Thanks