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.