3 Replies Latest reply: Apr 6, 2012 8:20 AM by Dennis Hoogenboom RSS

    Pivot table sums/totals

      I have a pivot table where there are a number of groupings and I want totals for each grouping.


      The problem is, that the totals are using the expression to calculate the totals.


      As opposed to a "Straight table" you cannot specify in a pivot table how the totals are calculated.


      In straight tables, you can specify "Sum" rather than "Expression" for the total calculation.


      Is there anyone who can help me with this?


      It is quite difficult to explain in few words, so I have included a sample with the problem.


      Best regards

      Steen Olesen