2 Replies Latest reply on Oct 25, 2018 7:42 PM by Aura Calderon

    Custom Grand Total

    Aura Calderon

      Hi all,

       

      I've been trying to find a way to customize a Row Grand Total based on a formula that counts the number of days the country was on target (50%) and divides it in the total number of days to return the % of days on target. As shown in the example attached the grand total is showing the row average (one of the default calculations for totals) but I want it to show for Spain 67%, for USA 83% and for China 0% that is the percentage of days those countries met the target.

       

      Appreciate you help with this one!