how to find out individual product sales percentage in total sales?

[Akina0929]

Hi,

  I have different products and its sales I want to show individual product sale percentage in total sales in gauge chart by selecting product.

[PrashantSangle]

Hi,

expression Sum(Sales)/sum(Total Sales)

Regards,

Prashant

[rahulpawarb]

Hello A B,

You can make use of below given sample expression:

//First Sum will give product specific sales amount and second Sum will give total sales amount
//Change the product name to get product level % sales
Num(Sum({<Product={'Product1'}>}SalesAmount) / Sum(TOTAL SalesAmount) ,'#,##0.00%')

P.S.: Gauge Charts are resource intensive (considering space on worksheet as resource). You can make use of Text box object or mini charts, if possible.

Regards!

Rahul

[PrashantSangle]

or

Sum(Sales)/Sum({<product=>}Sales)

Regards,

[jonathandienst]

With the expression:

    Sum(Sales) / Sum({1} Sales)

in the guage (ranging from 0 - 1), this will show 100% (value = 1) if nothing is selected, and will show the percentage of the selection.

You may want to modify the {1} to a set filter that ignores selections on a few fields, rather than everything.