BusinessObjects Board

Omitting rows on a tab if on another tab

building reports
#1

Is there a way to set up a filter that if a row appears on one tab of a report then it will not appear on another?

The criteria for why one might appear on the first tab could change so I would prefer not to keep remaking the filter on the second tab.

Thanks.

#2

Create a Var Tab 1 Filter variable that is something like this…

=If(Tab1 Criteria is met; 1; 0)

Then create a table filter on your first tab

Var Tab 1 Filter = 1

And a table filter on your second tab.

Var Tab 1 Filter = 0

Then just redefine the logic your Var Tab 1 Filter variable as needed.

Noel

1 Like
#3

That is genius in it’s simplicity.

Thank you.

1 Like