5 Replies Latest reply on Mar 30, 2020 2:42 PM by Phillip Le

    % to Goal Grand Total Calculation

    Shawn Suarez



      I have an issue on calculating % to Goal from a grand total perspective. I have recreated my issue using the superstore data and attached the workbook.


      Essentially, I have 4 regions and they all have hard coded Sales Amounts. I created the "Region Goal" measure as basically an IF [Region] = selected region THEN goal amount. What I want to do is create a calculated field that is % to Goal where it would be the regions sales amounts / Region Goal Amount. I have done that in the workbook and the calculation works for each region, however, once I add a grand total to the mix it throws off the grand total % to goal.


      Can someone show me how to get this to reconcile correctly?