3 Replies Latest reply on Oct 24, 2018 1:54 PM by Mavis Liu

    Grand Total of Table Calculation

    Michael Tralli

      I'm doing a YoY analysis of units sold with a table calculation that shows August 2018's "difference from" August 2017. From my table, location 1 sold 84 less units in 2018 than it did in 2017, location 2 sold 76 more, and location 3 sold 115 more.

       

      I want the grand total to be of only values created by the table calculation, therefore the 3,429 should read 107.

       

      Instead the 3,429 is the sum of total units sold in August 2018.

       

      Anyone know how to work around this and get the grand total of calculated values?