4 Replies Latest reply on Mar 31, 2016 1:25 PM by Michael Gee

    Calculating a Percentage in Grand Totals

    Michael Gee

      I am trying to create a text table that will be part of a dashboard.  The data includes a "% Change" column which is the "Dollar Change" column divided by the "2015 Estimate".  I pulled in the grand totals, but the % Change grand total is a sum of all the percentages.  Is there any way to have the % Change grand total show as the Dollar Change Grand Total divided by the 2015 Estimate Grand Total?  See below.