2 Replies Latest reply: Nov 5, 2013 4:50 PM by j i RSS

    creating totals in a pivot table


      Hi guys,

       

      I have a questions regarding the totals in a pivot table. I've noticed that if I create total by selecting Show partial Sums, it will display the sums of the measures. What if I don't want to display the sums?

      In the attachment you'll find a pivot table which shows up the Actual Prices, MP Prices, PY Prices Mth and PY Prices Avg for each Group Material, split for month.

      Now I want to show up these indicators at total level, not including the detail for Group Material.

      How can I do?

      Please, see my attchament.