Skip to Content
avatar image
Former Member

Using relativevalue and conditional formatting to implement monthly KPI targets have been met


I am using BI 4.1 sp6 and have just read through usage for relativevalue to retrieve a previous value from a measure and would like to know if it is possible to use this function together with conditional formatting (traffic light colors on cells) to highlight whether sales have been met or not in each preceeding months.

Question is what should the formula be for each cell under revenue? The tricky part is the need to count 3 consecutive months of YELLOW. If we look at June, the color should be RED because of the previous 3 months that revenue did not meet targets. Thanks in advance for your ideas!


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers