calculating % contribution

[#1]

Hi,

I have data similar to the one below

Name --- Sales

A               100

B               234

C               500

I need to know the percentage Sales contribution of A compared to A, B and C. Can this be achieved using aggr() function? How do I do it?

Thanks in advance

[abeyphilip · Accepted solution]

Hi,

If you are looking for % sales contribution of A w.r.to the total sales. Then you can use the TOTAL identifier for calculation. Attaching a sample.

If you are not looking for this, please mention the sample output required.

Regards,

Abey