2 Replies Latest reply: Oct 2, 2012 6:30 AM by Darwin Natividad RSS

    Pivot Table Shows Wrong Sum

    Darwin Natividad

      Please take a look at the column "QTR Growth (Product)" which is just the product of "QTR Index" and "Weight".

       

      It's total should be around 100% but what it is doing is multiplying Total of QTR Index by the Total of Weight.

       

      How can i correct this?

       

      Please advise.