Highlighting particular period values
I am trying to highlight the quarter values for couple of line items but when I am trying to apply conditional formatting it is applicable throughout the time dimension. Is there any way we can highlight particular period as shown in attachment.
Could anyone help me to tackle this problem?
Create a line item called Count and hardcode it to 1
Create another line item called CF - write a logic IF Count = 3 then 1 else 0
In you Cf window of New UX put the max to 1, color code it to yellow and min to 0 color code it to white
Hope that helps
Not forgetting to set the logic check line item to be formula and the count to be sum - otherwise it won't work4