4 Replies Latest reply on Jan 11, 2019 3:05 PM by Shawn Suarez

    % to Goal Grand Total Calculation

    Shawn Suarez

      Hello,

       

      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?

       

      Thanks!