I have a query with characteristics Person, COLOR & Calday and a Key Figure. I want to display exception in the query based on the characteristics COLOR value (2 values G and R. G for green and R for red).
The result looks like following
Day 1, Day 2, Day 3, Day 4,. ........, Day 30
Person Red , Green, Green, Red, ..........., Green (Cell color and Key figure calue shown in the cell).
I tried a couple of combination and couldn't get correct result. I may miss something or did something not right. I will be greatly appreciated, if someone can share the light.