3 Replies Latest reply on May 15, 2017 11:29 AM by Jim Dehner

    Subtotaling Issues with a Calculated Field

    Ryan Davis

      The attached is built via the most updated 10.1.

       

      I am trying to create a very simple workbook capturing headcount, total sales, and sales per headcount.  The latter measure I'm calculating using a simple table calculation of; sales/headcount.  But for whatever reason the subtotal is not functioning correctly when the numbers are rolled up by our location hierarchy?  The formula will work on the most granular dimension (Finance Description), but one level above Finance Description the subtotal is only running a sum.  For context the hierarchy order is; Segment, Platform, Finance Description.  I could not find any options to change the sub total behavior.

       

      Screenshot below and file attached;