how to Display top spend names dynamic

[kunkumnaveen]

Hello All,

                How to get dynamic top spends, i mean if we put 5 in the input box he should get top 5 spend customer Names ,if we put 2 then top 2 and so on......

i took a input box and created a variable to capture values: var_name

expression : sum(spend) and sum(spend)/sum(total spend)

how to pass input box value to these expressions

Thanks

Naveen

[tresesco]

One sample here (check Vikas's reply): Re: Top N statement

[passionate]

Hi Naveen,

There are multiple ways to do this :

I prefer Dimension Limit i.e Create a variable and use it in Dimension Limit.

Please refer the link below for more details:

http://www.naturalsynergies.com/q-tip-5-show-top-performers-common-but-not-too-trivial/

Regards,

Pankaj