Applying the Variables in Filters

system · August 30, 2004, 4:25pm

Hi Friends,
I have the objects as "Status Code " in dimension . I converted this into measure variable. I have different products , Among that one is own product and others are Competitor Product. In the Result i have to show the payer name , Product name and Product share in “CrossTab”.

For filtering the values , I have to find the difference of the status code between the product and competitor product . Then i have to filter, difference >0 .After i created this varible , if i click format filter . I couldn’t see the varible. I tried to follow someother ideas as if diff > 0 then 1 else 0 . It didn’t work . Actually this difference i am calculatins as

Maximum (status code ) where type indicator =1- min(status code) where type indicator =0.

I am in rush to finish this today . Can anyone please tell me some idea ? Thanks

psk (BOB member since 2004-08-04)

system · August 30, 2004, 8:02pm

Unfortunately, you can’t filter on an aggregate. Look here for a clear explanation of why, and for a hint for how to to a workaround.

Anita Craig (BOB member since 2002-06-17)