ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I sub-total 2 of 4items in a column in a pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/234072-can-i-sub-total-2-4items-column-pivot-table.html)

Jenzz22

Can I sub-total 2 of 4items in a column in a pivot table?
 
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


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com