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 y...
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

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