- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Color coding a pivot cell based on value on the earlier cell value
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 |
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I somehow managed to solve this by using above() function
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 :
Taoufiq ZARRA
"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "
(you can mark up to 3 "solutions") 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I somehow managed to solve this by using above() function