sale revenue greater then 100000

system · November 17, 2009, 11:44am

Hi
Report consist of Area, product and sales revenue.

Want to display following column :-
Area / Product / sales revnue

and in second tab(in same report) I want to display same field but for only those product , which having sale revenue in between 10000 20000 and 40000-45000

regards

GBS74 (BOB member since 2007-01-23)

system · November 17, 2009, 11:50am

So what have you tried so far?

Damocles (BOB member since 2006-10-05)

system · November 17, 2009, 12:07pm

Create a filter to the second table thereby showing the expected rows only.

Jansi (BOB member since 2008-05-12)

system · November 17, 2009, 12:34pm

Hi

How can I apply filter on measure

thanks

GBS74 (BOB member since 2007-01-23)

system · November 17, 2009, 12:46pm

You can create a flag variable like this.

flag=If([Sales Revenue]Between(10000;20000);1;0)

And then you can apply a filter to the second table using this flag variable like this.

flag=1

P.S: I don’t have Web-I right now. Use the above code as reference.

Jansi (BOB member since 2008-05-12)

system · November 17, 2009, 2:50pm

thanks

GBS74 (BOB member since 2007-01-23)