Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
My requirement is to color the below pivot table cells based on the values from its previous day. If the value is less than previous day mark it as Red, if its greater than previous value then make it Green.
Like below:
Team | 5/7/20 | 5/8/20 |
A | 100.00 | 100.00 |
B | 92.59 | 96.30 |
C | 100.00 | 92.00 |
My data is getting loaded from sharepoint and looks like this:
Team | Date | Value |
A | 5/7/20 | 100.00 |
B | 5/7/20 | 92.59 |
C | 5/7/20 | 100.00 |
A | 5/8/20 | 100.00 |
B | 5/8/20 | 96.30 |
C | 5/8/20 | 92.00 |
Please note that I can't modify at Load script level due to some other factors.
Thanks
Can someone please help me here.