Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
One sample here (check Vikas's reply): Re: Top N statement
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