Skip to Content

WEBI Conditional Format a measure per period

Nov 22, 2017 at 07:14 AM


avatar image


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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers