Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Coud someone guide me on how to do the aggregation of the sales at co. level in a pivot table chart.
I would like to sum the total sales $ by the total sales made per company. Would like to know how to write the expression for it.
Seller | Co. Name | Sales No. | Amount |
DD | Water | 5369 | $6,200.00 |
EE | Sun | 5711 | $2,000.00 |
EE | Sun | 5720 | $1,500.00 |
FF | Light | 7821 | $800.00 |
PP | Light | 9248 | $7,100.00 |
KK | Water | 5694 | $4,500.00 |
LL | Rain | 6200 | $2,300.00 |
Thanks
Hi
Are you looking like this
Dim: Co. Name
Exp: =Sum(Amount) / Sum(total Amount)
for total by company
Sum(Amount) / Sum(TOTAL <Co. Name> Amount)
so % for Water for SalesNo 5369 = 6,200. / (6,200+4,500)
Thanks, guys.. it's closed to what i need..