12 Replies Latest reply: Jun 19, 2013 3:48 PM by rodrilauro RSS

    Partial Sum Totals Error in Pivot Table

    yaman1510

      Hi All,

       

      I have created a pivot table and I'm using the partial sum total on one dimension from the presentation tab. The problem is the incorrect totals that are coming up. Any suggestions on how to correct the partial sum totals would really be appreciated.

       

      Thank you in advance.

        • Partial Sum Totals Error in Pivot Table
          swuehl

          Pivot tables will evaluate your partial sums as expression total, while you probably expect a sum of rows.

           

          Please check the Help pages for 'Sum of rows in pivot tables' using advanced aggregation.

           

          Your expression might need to be changed to something like

           

          =sum( aggr( sum(Value), TableDimension1, TableDimension2, ...))

           

          Hope this helps,

          Stefan

          • Re: Partial Sum Totals Error in Pivot Table
            rodrilauro

            Hi,
            Can someone help me with this?

             

            I have almost the same problem. I have an Expression  that is the multiplication of two parts (Part A * part B).
            When I make the sum of my own for the two parts, and then multiply both TOTALS it is correct. But it is not the correct total for the pivot grid.

             

            This is the Expression

            (Sum(STOCK_AL_CIERRE_AJU)  - Sum(VENTA_AJU) + Sum(CAJAS))     // PART A

                 *   

            (sum(NIV)/sum( CAJAS)) // PART B

             

             

            I only use one Dimension, it is YearMonth.