Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
expression Sum(Sales)/sum(Total Sales)
Regards,
Prashant
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
or
Sum(Sales)/Sum({<product=>}Sales)
Regards,
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.