In attach Pivot table, in overall status we want to view G,A and R .
e.g. if all values are G then Overall status should be G
If 1 value is R and all others are green then Overall Status should show R
If 1 value is A and all others are green then Overall Status should show A
If 1 value is A and 1 value is R and all others are Green then overall status should be R
It's working in most of the cases but not working in few case, In one of the overall status is showing W even one value is R..
Can we write some expression so it show correctly all the time?