Calculation in pivot table

[Anonymous]

why the calculation in pivot table is not accurate it give a wrong number, but in straight table it's right !!

[MK_QSL]

Provide sample application or sample data to work...

[Anonymous]

qlik example

[Anonymous]

I put it in last comment.

regards.

[MK_QSL]

There are so many information and objects in your qvw. We need to have only those two where you are trying to match!

[preminqlik · Accepted solution]

hi there,

It depends on what is the level of your aggrigation,

use the following exp

=sum(aggr(

((sum(QTY) + (vQty2)) * (sum([Unit Price])* (1+vSales2/100)))

-

(

((sum([Unit Cost]) * sum(QTY))) * (1+vCost2/100)

)

,

[Customer Name],

[SOP Number],

Item_Description,

[S_Location Code]

))

[Anonymous]

Thanks a lot.