4 Replies Latest reply on Jun 9, 2016 7:42 AM by Mark Ackerman

    Trouble adding subtotals

    Mark Ackerman

      I am trying to create a column chart that shows two measures, each split into two categories with a total of those two categories to the left of the groups.  For each measure the following groups should show (Orange measure "Total", Green "AL", Blue "IL").  I tried to create subtotals for each measure, but the subtotals options was grayed out.  I was able to create totals for each measure, which gives me all the data I am looking for, but the bars are not in the desired order.  Does anyone know what I can do to get the chart below in the desired order?

       

       

      Here's an Excel version of the chart that shows what I am looking for.