0 Replies Latest reply: Aug 24, 2009 2:07 PM by ronliwanag RSS

    Summation of Total in PIVOT table

    ronliwanag

      Hi QV Experts!

      Good day!

       

      I have a pivot report wherein the total sum of the expression field "Total Cost" with respect to the dimension field "Mat Grp" using the "show partial sums" function present a different Total/Output than what I expect which should be the summation of all values across the "Total Cost" field and not the default 'Expression Total'. Kindly advice on how I can correct this since this is the remaining issue I encounter using pivot.

      Thanks in Advance,

      Ron