4 Replies Latest reply: Feb 20, 2018 6:03 AM by omar bensalem

# Sales from top 10 location Vs Total Sales in Gauge chart

Hi Experts,

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

Thanks ,

Pooja

• ###### Re: Sales from top 10 location Vs Total Sales in Gauge chart

Hi,

Can you attach sample data ? or a QVF ?

• ###### Re: Sales from top 10 location Vs Total Sales in Gauge chart

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)

• ###### Re: Sales from top 10 location Vs Total Sales in Gauge chart

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

Thanks,

Pooja

• ###### Re: Sales from top 10 location Vs Total Sales in Gauge chart

It all depend on what u have.

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