2 Replies Latest reply on Feb 23, 2017 8:21 PM by y zhu

    How to add a subtotal to a subcategory

    y zhu

      I want to add subtotals to the Product subcategories like this:

        

      RegionProductSum(Revenue)
      AX15
      Y20
      Z55
      BX30
      Y40
      Z70
      SubTotalX45
      Y60
      Z125

       

      In Tableau, if I check Analysis>Totals>Show Column Grand Totals, I only got the Grand Total without subtotals to the subcategories (Product X,Y,Z):

         

      RegionProductSum(Revenue)
      AX15
      Y20
      Z55
      BX30
      Y40
      Z70
      Grand Total 230

      What should I do to get the desired results?