4 Replies Latest reply: Jun 16, 2014 1:17 PM by Braham Edwards RSS

    Advanced Pivot Table Question

    Braham Edwards

      I would appreciate some input from the forum


      I would like to produce a pivot table with two dimensions and one calculated value. The dimensions are Year and month, and category, while the value is Sum(Amount). By using the pivot table with 'Show Partial Sums' ticked I get a pivot tale for 201401, category A, Category B, Category C and a subtotal for 201401. So far so good. However the problem that I have is that for my Total I only get a total of all categories. What I would like is a total per category for all the data. It would therefore be a total for category A, Category B and Category C for all Year/Month.