% of whole sales.

[#1]

Hi:

Want to create a pivot table with two expressions, one for the total sales by product (first dimension) and the second for the % that this product correspond considerating all the sales of the other products. How can I calculate this second column?

I have been trying with aggr and with two diferent tables. Im adding my sampe project...

Thanks in advance.

Prouduct	Sum(Sales)	% of Whole Sales
Product A	10	10%
Product B	20	20%
Product C	20	20%
Product D	20	20%
Product E	30	30%

[#2 · Accepted solution]

check out the attached....is that what you're looking for.

[#3]

If you add sum(Cantidad)/sum(all Cantidad) to your pivot table, does it not give the result's you are after?