1 Reply Latest reply: Dec 21, 2012 7:27 AM by microlabs RSS

    Pivot Table Sum problem

      Plz help me solving this problem in sum in PIVOT table for following table

       

       

      The result i get is  correct for 2011 and not for 2010. What might be going wrong in my pivot.? I am using 2007 excel.

       

      Its like following table

       

       

      Thanks

       

      Sumant

        • Re: Pivot Table Sum problem

          Oops tables not appearing in previous post.

           

          ItemSales-2010 USD'000Sales-2011 USD'000
          a178206
          a21
          a3868
          a116
          b4859
          b53
          b179211
          b2234
          b11
          b23
          b11
          c796943
          d164254
          e01
          e00
          f97132
          g5595
          h4794
          i3132
          j00

           

           

          For this pivot result is as follows. for summation of each item for sales of both years.

           

          ItemSum of Sales-2010 USD'000Sum of Sales-2011 USD'000
          i132
          j00
          b9312
          a7281
          g195
          h194
          e01
          c9943
          d2254
          f2132
          Total322144

           

           

          Why the sum of 2010 comes wrong?

           

          Thanks

           

          Sumant