Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can you help me to get solution of implementing sales from top 10 locations vs total sales in gauge chart
Thanks ,
Pooja
Hi,
Can you attach sample data ? or a QVF ?
sum({<location={"=rank(sum(sales),location)<=10"}>}sales) / sum(total sales)
or
sum({<location={"=rank(sum({1}sales),location)<=10"}>}sales) / sum(total sales)
(depends on how u define top 10 locations)
ps: u can alter this :
sum(total sales)
as
sum(total {<location>} sales)
or
sum(all sales)
It all depends on what u're willing to analyze
Per analogy; here's top 3 vs Total : (a,c and d)
Thanks for your help bud has not worked as I wanted.
Thanks,
Pooja
It all depend on what u have.
Can u share a screenshot of what u had using this? and what u're expecting maybe?