7 Replies Latest reply: Sep 4, 2014 4:44 AM by Ashfaq Mohammed RSS

    Pivot Table Total

      Hello,

       

      I made a pivot table for invoicing monthly costs. Attached is the screenshot for May. As you can see, cost centers, projects, and the month are displayed as columns, whereas each team is presented on the top horizontally (required by the management). I would like to add a total for each project and each team at the end of each row/column, but I couldn't get it right. The option "Total mode" in the expression tab is grey, which means I can only crack this from the expression itself, I suppose.

       

      My current expression is simply sum(Allocation_Amount), and the field names for project and team are Project_Name and Party_Name, respectively. Please help me with it. Thank you very much in advance.

       

      Regards,

      Tuan