Forum Discussion

andytmcc's avatar
andytmcc
Icon for Helper I rankHelper I
4 years ago
Solved

Add red/green arrows in table column based on whether value has changed since last year.

I currently have a 2 column table on my page. First column gives the name of 18 geographical areas and the second column gives a numerical value for each area. The page has an overall year filter so ...
  • andytmcc's avatar
    4 years ago

    Hi Henry, sorry for slow response. I came upon a solution by creating a calculate column that brings in the previous years value for each row. I then created a second calculated column that assigned a value 0, 1 or 2 dependent on the difference between this years and previous years values. These numbers (0,1,2) were then used for conditional formatting.