Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In the attached qvw I want to see only Customers that are in a range of e.g. Margin% values 15%-19%.
I want the range to be specified by the user.
Any ideas?
Regards,
Helen
How about the attached (see the dimension).
Any help?
Change your dimension to:
=if(aggr(Sum (Margin)/Sum(Sales), Customer)>=.15 and aggr(Sum (Margin)/Sum(Sales), Customer)<=.19, Customer)
And suppress values when null (see attached)
Hi Nicole,
I use variables to specified the range, it works perfectly in every case exept the one that the min and the max number is the same.
=if(aggr(Sum (Margin)/Sum(Sales), Customer)>=.15 and aggr(Sum (Margin)/Sum(Sales), Customer)<=.15, Customer)
????
It just doesn't work for .15 to .15 (it does work for .16 to .16--see attached). I'm guessing that your number is actual .14 something that is rounding up to .15 so it isn't actually equal to .15 which is why you're not getting anything on the chart.
You are right!!!
But we are using rounded numbers, so when the user gives 15 it has to be "translated" to 15.0-15.5 I suppose. Do you have any good idea about this as well?
Appriciate your help,
Helen
How about the attached (see the dimension).
Hi Nicole,
I had already did it myself and I forgot to inform you. Yes, that's right it works fine and I am gonna vote your answer as correct.
Thanks a lot for your time.
Regards,
Helen
I'm glad you were able to get it to work
This is really helpful and u just saved my day. Thank u so much!!