Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Gurus,
I have a strange phenomena in QV. While expression results in correct result, the total sum does not result in the correct summation per individual lines.
In expression, we have such expression.
Y is an input value. Initialised as 1.
The result should be 818, but it indicates in 7,463 in Pivot Table.
If you possibly open the attached file, upper is straight table, with total mode 'Sum of Rows'. This results in 818. While Pivot Table result in 7565. In fact, if we export into Excel, we only have 818!
*Since this is only on of the columns in a report in the production release, Pivot table is mandatory.
I'd appreciate for your support.
Hi Atsushi ,
This a normal behavior, in a pivot table the total is calculated always as an expression total and not as a sum of rows What you have to do to get the same result as in the straight table is to modify the expression to incorporate the sum on it like in your modified document attached.
I hope it helps.
Carlos
Hi Atsushi ,
This a normal behavior, in a pivot table the total is calculated always as an expression total and not as a sum of rows What you have to do to get the same result as in the straight table is to modify the expression to incorporate the sum on it like in your modified document attached.
I hope it helps.
Carlos
Dear Carlos,
I appreciate for the correction. Yes this is the desired result.
Atsushi