Forum Discussion
andytmcc
Helper I
4 years agoAdd 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 ...
- 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.
v-henryk-mstf
Community Support
4 years agoHi andytmcc ,
Thanks for your solution. If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry