Aggregating total sales in a expression

[Anonymous]

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

[MayilVahanan]

Hi

Are you looking like this

Dim: Co. Name

Exp: =Sum(Amount) / Sum(total Amount)

[vinieme12]

for total by company

Sum(Amount) / Sum(TOTAL <Co. Name> Amount)

so % for Water for SalesNo 5369 = 6,200. / (6,200+4,500)

[Anonymous]

Thanks, guys.. it's closed to what i need..