Pivot table - Overall summary issue

[pawwy1415]

Hi,

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?

Thanks

PK