Hello All,
I need to create Pivot that table that would compare in two dimensions and update Status for each Run ( Pass, Fail, No Run )
Also Pass filled with Green Color and Failed with Yellow
| | Run 1 | Run 2 | Run 3 | Run 4 | Run 5 |
| Test 1 | Pass | Pass | Pass | Pass | Pass |
| Test 2 | Pass | Pass | Fail | Pass | Pass |
| Test 3 | Pass | Pass | Pass | Pass | Pass |
| Test 4 | Pass | Pass | Pass | Fail | Fail |
| Test 5 | Pass | Pass | Fail | Pass | Pass |
| Test 6 | Pass | Pass | Fail | Pass | Pass |
| Test 7 | Pass | Pass | Pass | Pass | Pass |
| Test 8 | Pass | Pass | Fail | Fail | Pass |
| Test 9 | Pass | Pass | Pass | Pass | Pass |
| Test 10 | Pass | Pass | Pass | Pass | Fail |
Any help would be great.
BR.
