[ASK] Different result with total Sum Rows

[rendiyan]

‌

hello qlikview developers,

i have an issue i want to ask.

so i have a straight table with dimension A, B, and ABC expression.

My expression formula is :

If(sum(A)/sum(B)>1,1,sum(A)/sum(B))* sum(C)

Also i give total of rows sum in my straight table.

And then i create a pivot table with same dimension and expression as above.

Here's when the strange thing happen.

When i expand all dimension, i got the same row result.

But when i only expand for dimension A, i got the different result from the total of rows sum in my straight table.

Is there any explanation why and how to solve this?

Thanks a lot before,

Best Regards

[settu_periasamy]

Detailed discussion here

Eh?! Pivot Table Total <> Straight Table Total