Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
check out the attached....is that what you're looking for.
check out the attached....is that what you're looking for.
If you add sum(Cantidad)/sum(all Cantidad) to your pivot table, does it not give the result's you are after?