Forum Discussion
andytmcc
Helper I
Helper IAdd 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 ...
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.
andytmccHelper I
Helper IHi 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.