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.
Try to create a calculation dimension like below:
=If(Month<[Month+1] and [Month+1]<[Month+2] and [Month+2] <[Month+3],Dealer)
create a variable vTopN and use the same in Dimension Limits
select Show only largest =$(vTopN ) values .
Create a Input box and assign this variable and let user to select his choice top value.
Hope this will be helpful else please let me know
Stealing ideas from Sasi and Rahul to come up with the attached sample. See if it helps
Test_Top and Diff (1).qvw 172.0 K