Sales from top 10 location Vs Total Sales in Gauge chart

[Anonymous]

Hi Experts,

Can you help me to get solution of implementing sales from top 10 locations vs total sales in gauge chart

Thanks ,

Pooja

[YoussefBelloum]

Hi,

Can you attach sample data ? or a QVF ?

[OmarBenSalem]

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)

[Anonymous]

Thanks for your help bud has not worked as I wanted.

Thanks,

Pooja

[OmarBenSalem]

It all depend on what u have.

Can u share a screenshot of what u had using this? and what u're expecting maybe?