5 Replies Latest reply on Nov 16, 2017 6:13 AM by Jim Dehner

    Row Sub-Total for dimension in a column

    Amir Vastani

      I have 2 Dimensions in Columns, Category, Year, 1 in Rows i.e. State and SUM(Sales) in Rows as the worksheet setup.

       

      I have a Bar chart representation of Sales over time and need to create a Sub-Total for the Category by Year in the same worksheet. I can do this in a separate worksheet but I need it in one so I don't have 2 scroll bars, is it possible?

       

      Using Analysis, Totals, add all sub-totals, I don't get the sub-total for each year for all Categories as an option in the pill drop down. Is that a tool limitation?