9 Replies Latest reply on Jun 23, 2016 9:17 AM by Yuriy Fal

    Grand Total and Calculations

    Ryan Meehan

      Hi all,


      I recently posted a question (Top N with "Others" for Multiple Measures ) to get a table that displays Top N with "Others" and the ability to sort on different metrics. Now I am trying to add a Grand total to the bottom, but I need a single column to be a calculated measure based on the other two column's totals instead of the summation of every value in that column.


      My table is set up as following:


      Inventory (sum of total units), Sales forecast (sum of total untils), and days of supply/forecast (inventory divided by sales forecast). I want the grand total to sum the inventory and forecast columns, but then apply the calculation for days of supply.


      Is this something that is possible?