9 Replies Latest reply: Apr 4, 2014 7:44 AM by NagaArjun Krishnamoorthy

# Top 10 sales

Hi Guys ,

I have  a table

Sno       product              sales

1               P                    100

2               Q                    150

3               R                    110

4               P                    200

5               Q                    170

6               P                     240

7               P                     160

--

--

--

--

--

Like this i haev number of rows , now my Question is

I want to caluculate Top 10 sales of product='P' in a  chart  , Can anybody please assist me on this

Thanks

Nani

• ###### Re: Top 10 sales

Please take a look at the example.

• ###### Re: Top 10 sales

Thanks sudeep,

But in my case i have to show two exp in a pie chart like below

1) Top ten sales of a product 'p'

2)sales of remaining products

Only exp i have to use here no dimensions ..

Thanks

Nani

• ###### Re: Re: Top 10 sales

Please take a look at the example. I've done it for top 4 but you can change it to top 10.

I'm still looking to make it little more optimized.

• ###### Re: Top 10 sales

Can any one plese assist me on this...

• ###### Re: Top 10 sales

Here is  my Question

i want to write 2 exp in pie chart

1)top ten sales of product 'P'

2) remaining sales of prodct 'P' only

Regards

Nani

• ###### Re: Top 10 sales

Hi Nani,

I hope you are trying to display the top 10 sales of product 'P' and other than top 10 sales of the same.

In pie chart only one expression can be plotted at a time. To get this you can use Conditional Expression.

Regards.

PS

• ###### Re: Top 10 sales

= if(rank(sum({\$<product={"P"}>}sales))<10,sum({\$<product={"P"}>}sales))

• ###### Re: Top 10 sales

Hai Nani,

If(Rank(Sum({<[product ]={'P'}>}Sales),10)<=10,Sum({<[product ]={'P'}>}Sales))