Skip to Content
Former Member
Sep 10, 2013 at 06:19 PM

Is this possible in Query?


Hi Gurus,

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.