Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My data looks like below. My requirement is to highlight the cells based on previous value and mark them either Red or Amber.
If the current cell is less than its previous cell, then the value of the current cell should be Red,
If the current cell is equal to its previous cell, then the value of the current cell should be Amber,
otherwise default.
Can you please suggest what should be my text color under Edit Expression of a Pivot Table
Data:
Team | ReleaseMonth | Targeted Regression Scenarios | Automated | Manual |
A | Dec 19 | 147 | 122 | 25 |
A | Jan 20 | 155 | 122 | 33 |
A | Feb 20 | 152 | 100 | 52 |
B | Dec 19 | 2793 | 2747 | 46 |
B | Jan 20 | 3121 | 3051 | 70 |
B | Feb 20 | 105 | 50 | 55 |
What I want is: a Pivot Table
Team | ReleaseMonth | Targeted Regression Scenarios | Automated | Manual |
A | Dec 19 | 147 | 122 | 25 |
A | Jan 20 | 155 | 122 | 33 |
A | Feb 20 | 152 | 100 | 52 |
B | Dec 19 | 2793 | 2747 | 46 |
B | Jan 20 | 3121 | 3051 | 70 |
B | Feb 20 | 105 | 50 | 55 |
I somehow managed to solve this by using above() function
I propose this solution :
on load Script :
Data:
LOAD rowno() as ID,previous(Manual) as P_Manual,previous("Targeted Regression Scenarios") as P_Targeted,previous(Automated) as P_Automated,* INLINE [
Team, ReleaseMonth, Targeted Regression Scenarios, Automated, Manual
A, Dec 19, 147, 122, 25
A, Jan 20, 155, 122, 33
A, Feb 20, 152, 100, 52
B, Dec 19, 2793, 2747, 46
B, Jan 20, 3121, 3051, 70
B, Feb 20, 105, 50, 55
];
then in expression -> Text Color for [Targeted Regression Scenarios]
if([Targeted Regression Scenarios]<P_Targeted,red(),if([Targeted Regression Scenarios]=P_Targeted,yellow()))
same of other expression for example :
if(Automated<P_Automated,red(),if(Automated=P_Automated,yellow()))
if(Manual<P_Manual,red(),if(Manual=P_Manual,yellow()))
output :
I somehow managed to solve this by using above() function