Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional format: This Year vs Last Year

Hi Guys,

 

I have a matrix table (see link attached) showing the values this year and values for the same period last year. What is the best way to include green, amber or red arrows next to this year's figures. So it should be green if the figure is greater than the previous year, amber if the figure is the same and red if this year's figure is less than last year's.

 

https://1drv.ms/u/s!AhEw68UYqcc6gxh5JbUie_w1e52L?e=y4k7tb

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi All,

    I managed to sort it out by intially creating a calculated field using a switch statement and then using the outcome values of the switch statement to create a conditional format using icon arrows only.conditional formatswitch statement

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi All,

    I managed to sort it out by intially creating a calculated field using a switch statement and then using the outcome values of the switch statement to create a conditional format using icon arrows only.conditional formatswitch statement

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous ,

      It's glad to hear that your problem has been resolved. And thanks for sharing your solution here. Could you please mark your post as Answered if there is no anything else need to help about this thread? It will help the others in the community find the solution easily if they face the same problem as yours.  Thank you.

      Best Regards