0 Replies Latest reply: Jan 3, 2018 7:29 AM by P Kumar RSS

    Pivot table - Overall summary issue

    P Kumar

      Capture.PNG

       

      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