11 Replies Latest reply: Feb 21, 2017 7:07 AM by Sunny Talwar

# Top dealers and consistent growth...

Hi,

I want those dealers who has consistent growth...

but top 5,10,15...on the choice of selection...

Top is based on the Increase column (Column 3- Column 1)...

Kindly help me with this issue..

I am able to achieve top 5 and consistent growth dealers separately..but when I put both the condition together..It doesn't work...

PFA qvw and data..

• ###### Re: Top dealers and consistent growth...

You want to see top 5 based on Increase column?

• ###### Re: Top dealers and consistent growth...

Firstly I want those dealers only...who are consitently growing in 4 months...

After that I want to apply...Top N Dealers.

Regards,

Kavita

• ###### Re: Top dealers and consistent growth...

Hello Kavita,

Trust that you are doing well!

I agree with stalwar1. You can further modify his solution to add -

1. Variable - vTop with definition Count(TOTAL Dealer)

2. Slider object for Top N analysis with Data = Variable(s) - vTop, Mode = Single Value, Value Mode = Continuous/Numeric, Min Value = 5, Max Value = 50 and Static Step = 5

3. Change the Straight Table expressions as below-

Month :  If(Rank(Increase) <= \$(vTop), Month)

Month+1 : If(Rank(Increase) <= \$(vTop), [Month+1])

Month+2 : If(Rank(Increase) <= \$(vTop), [Month+2])

Month+3 : If(Rank(Increase) <= \$(vTop), [Month+3])

Increase : If(Rank(Increase) <= \$(vTop), Increase)

Hope this will fetch expected results.

Regards!

Rahul

• ###### Re: Top dealers and consistent growth...

I want those dealers who are consistently growing in all 4 months...firstly this condition apply..n den i want top N Dealers...

For e.g ANJ300736 is growing in all 4 months.

NRM400224 will not come as it falls on 2nd month...

Hope now u understood my issue...

Regards,

Kavita

• ###### Re: Top dealers and consistent growth...

Hello Kavita,

Replace the Dealer dimension with calculated dimension - =If(Month<=[Month+1] AND [Month+1]<=[Month+2] AND [Month+2]<=[Month+3],Dealer)

Hope this will solve your concern.

Regards!

Rahul

• ###### Re: Top dealers and consistent growth...

HI,

Try to create a calculation dimension like below:

step1:

=If(Month<[Month+1] and [Month+1]<[Month+2] and [Month+2] <[Month+3],Dealer)

Step2:

create a variable vTopN and use the same in Dimension Limits

select Show only largest =\$(vTopN ) values .

Step3:

Create a Input box and assign this variable and let user to select his choice top value.

Cheers

• ###### Re: Top dealers and consistent growth...

i have an inline field..which has 5,10,15,20 values..which is used for Top N dealers..

I don't want to apply on dimension limit...

I want to write such expression which will give me continuous growth of dealers with top N dealers (On the selection of field).

• ###### Re: Top dealers and consistent growth...

HI,

If it from a filed then create same variable with expression =Max(Top N)

What will be the problem if you you can use Dimension Limits , any specific reason?If so,