3 Replies Latest reply: Apr 25, 2016 9:59 AM by Nakul Navre RSS

    Summary table

    Andrew Thomas

      Hi

       

      I have a pivot table that has a calculated expression based on 2 other expressions. I want to be able to create a summary table of the totals but when I add totals the table calculates the expression for each row and so the values are wrong at the total level when I collapse my pivot table. I changed the table to a straight table that allows be to sum the column but then I can't get a summary view.

       

      What I'm looking for is to be able to create a summary view that totals the columns and doesn't perform the calculation for the total rows