Highlighting particular period values

AbhishekGoswami
AbhishekGoswami
in User Experience

AbhishekGoswami_0-1666335871242.png

Hi All,

 

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?

 

Thanks

Tagged:

Answers

  • Misbah
    Misbah

    @AbhishekGoswami 

     

    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

    Misbah

    Miz Logix

  • andrewtye
    andrewtye

    Not forgetting to set the logic check line item to be formula and the count to be sum - otherwise it won't work

Categories