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