Skip to Content

WEBI Conditional Format a measure per period


I am fairly new to WEBI and have have run into some trouble figuring out how to formulate a conditional formatting one of the directors is after.

I currently have a cross Table with Job # as vertical catagory and Period as Horizontal.

I wish to use conditional formatting to reference the previous months figure, but are under the same dimension.

For example.

"IF [Measure] of [Period] is 10% less than [Measure] of [Period]-1 {The Month before} then RED"

So would be relative to each month.

This is the first of the conditions we wish to put in place there are others including, if it has dropped over the past 3 months then red.

Main problem is not knowing how to reference a different period within the same Dimension.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers