5 Replies Latest reply on Jun 11, 2015 6:44 AM by Karen Massey

    Custom Subtotals on Specific Field

    Janie Carlisle

      I want to use automatic subtotals but want to specify on what grouping the subtotals should be applied. For example, I have a say MAJOR field, then several minor fields. There may be changes within the minor fields as far as the measures that apply but I want the subtotals to be on the MAJOR field. Here's an example for clarification

      State     City     Store     Sales$     Number of Items     Number of Customers


      I want the subtotal to be on STATE, not on each minor field (ie, city and store), Does this make sense? Thanks for help.