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?

       

      Thanks!