Can any please help mem I'm stuck with a percentage column..
I have a pivot table like the one below and I need to add a column with the % of each supplier for each customer:
Customer Supplier # items by supplier %
A S1 10 I'd like to get 10/(10+5) ; I get 10/(10+5+12+22)
A S2 5 I'd like to get 5/(10+5) ; I get 5/(10+5+12+22)
B S2 12 I'd like to get 12/(12+22) ; ...
B S3 22 I'd like to get 22/(12+22) ; ...
To count the number of items i use this formula:
For the % colums I tried in this way but I get a wrong result because I don't get the right % calculated for the total items for each customer, but I get a percentage based on the total number of items:
=count(distinct ITEMS)/count(distinct total ITEMS)