Formula changes to specific segments of Columns

building reports desktopintelligence
9

In brief:
In Reporter create a dimension variable “Flag” defined along the lines of:

= <Region> = " EAST"

Then use a WHERE clause for your measure along the lines of:

= <Measure> WHERE ( <Flag> = 1)

See also FAQ entry here.

You problem seems to be that for IF…THEN… ELSE to work the referenced variable must exist in the footer of your block, which it does not.

Andreas :de: (BOB member since 2002-06-20)