This content has been marked as final. Show 2 replies
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!