filtering calculated Value

[farhy]

Hi,

I have one dimension and 2 values, say the amount of this year and the year before. Then I create a variable to get the percentage.

Now I want only all the values, that are greater than 10%, how can I get this?

Custumer_name amount_a amount_b percentage


Thanks everyone.
farhy

 

[nimmy99]

May be you can implement the % object in your designer and filter it

 

[skrandel]

No, don't do it that way. What you need to do is build a variable that does: =if <value> > .10 then 1 else 0

Then build a ranking on your customer and the new varialbe. Show only the top 1.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com