I have a query result . i want to append the three colors based on values and the table is dynamic based on the time frame
column Messages and Nov20 - no change should be same
Messages | Nov 20 | Dec 20 | Jan 20 | Feb 20 |
Messge 0 | 0 | 1 | 0 | 0 |
Messge 1 | 1 | 3 | 1 | 1 |
Messge 2 | 11 | 0 | 0 | 0 |
Messge 3 | 1 | 0 | 0 | 0 |
Messge 4 | 9 | 5 | 0 | 0 |
Messge 5 | 1 | 1 | 0 | 0 |
Messge 6 | 1 | 1 | 0 | 0 |
Messge 7 | 0 | 1 | 0 | 0 |
column Dec20 Jan20 Feb20 - values should append field value and with color value
Messages | Nov 20 | Dec 20 | Jan 20 | Feb 20 |
Messge 0 | 0 | 1 GREEN | 0 RED | 0 YELLOW |
Messge 1 | 1 | 3 GREEN | 1 RED | 1 YELLOW |
Messge 2 | 11 | 0 RED | 0 YELLOW | 0 YELLOW |
Messge 3 | 1 | 0 RED | 0 YELLOW | 0 YELLOW |
Messge 4 | 9 | 5 RED | 0 YELLOW | 0 YELLOW |
Messge 5 | 1 | 1 YELLOW | 0 RED | 0 YELLOW |
Messge 6 | 1 | 1 YELLOW | 0 RED | 0 YELLOW |
Messge 7 | 0 | 1 GREEN | 0 RED | 0 YELLOW |
You asked a very similar question (which I answered) here - the main difference being not adding the colour value to the first date column. As I hinted at in the other post, it might be easier to solve from the original query used to generate the table. Are you able to share this? Did you try the technique shown in the other post?