Hiding rows in a report

[boani]

Hello,
Is there any way to hide rows in a report based on some cond.I have a report with foll objs -
State
City
Revenue
I want to hide rows with revenue < 10000.Is it possible?

thanx
boani

 

[hotcross]

Go to Format/Filters, hit Define and add a filter with a formula of &quot;= <Revenue> > 10000 (or whatever you want)

 

[boani]

hi
thanx hotcross.but i did not remember to mention one issue.the 'revenue' obj is the result of formula involving xtended syntax.so i am not able to apply a filter on it.wat else can be done?

 

[blom0344]

Hi Boani,

Create a check-variable that gives back a 'Y' for values over 10000 and 'N' for those under 10000. Apply a filter on this new variable.

<variable> : =If <revenue> > 10000 Then 'Y' Else 'N'

If you succeed to create this variable as a detail or a dimension you can put a filter on it. If the variable defines itself as a measure , BO does not allow a filter.
(only filters on universe-defined measures are allowed in BO, which is quite bad!) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com