What % of total sales is the number one product

[Daryn]

Hi all,

Thanks in advance for taking the time to read this and propose a solution if possible.

I am trying to show as a %, the top selling product of all sales. I thought the below was right, but shows as 0.

=(Sum({<[Prod_series]={"$(=FirstSortedValue({<[Prod_series]={"1"}>}))"}>}[NETWR]) /  Sum([NETWR])) * 100

Looked so simple, yet here I am, stuck!

I also tried with rank as well, I don't mind which solution someone provides.

Thanks as always,

Daryn

[Chirantha · Accepted solution]

Please see if this helps

=Sum({<Prod_series={"$(=FirstSortedValue(Prod_series, -aggr(Sum(NETWR), Prod_series)))"}>} NETWR) / Sum(TOTAL NETWR)
 

[Daryn]

Thank you Chirantha, I just had to add NUM at the start and ,'0.0%' at the end, as it wasn't displaying properly as a %.

But your solution was prefect apart from that 👍.  Really appreciate your time and knowledge.

Regards Daryn