6 Replies Latest reply on Nov 21, 2013 12:40 PM by Jonathan Drummey

    Subtotals calulated on entire data set

    Larry Hill

      I am trying to figure out how I get my subtotals to calculate against the entire data set as opposed to the top N items or dimensions I have selected. In my example, I have top N items by Region but I want to see the actual region totals for all products in my subtotals instead of the summed totals of the items in the chart. In my example, Central subtotal should show 519,862 regardless of the number of items I select. The Grand total should also be against ALL items not the selected ones.