7 Replies Latest reply on May 9, 2018 10:11 PM by Red TypeR ha

    Custom Grand total - Show same No. twice but sum only one in Grand Total

    Red TypeR ha

      Hi Guys,

       

      My bad, sry that i didn't tell quite detail. As the No. have to be calculated in Avg (Avg(No.) . and the grand total  has to be sum of above (Total using(Sum))   as Below,

      i have uploaded the updated file.

       

       

       

       

      I have a sample dataset where A and C have to display the same No., however the grand total has to sum only one of it as below. Hope anyone can help. Thx