Pivot Table Partial Sum Showing Problem

[#1]

Hi All,

I am using pivot table to show some calculation. Unfortunately, the partial sum function shows incorrect value. I have already found some post in community which are about the showing problem of partial sum function. I tried to use AGGR function into the expression to solve it, but it is failed.

For my case:

There are some dimensions, like region, product name, part name, quarter and month. The partial sum is shown by region.

Also, there are 2 expressions where one of the expressions (QTY) can show correct value, while another expression (AMT) show incorrectly.

The showing problem exists only when I select currency - Base, that means selecting other currencies like JPY, USD shows the partial sum correctly.

The QVW file is attached here.

Please help me on this.

[sunny_talwar]

May be try your AMT's expression:

Sum(Aggr(YourExpression, YourChartDimensions))

[#3]

Hi Sunny

I tried your suggested expression before, but the value is still incorrect.

Thanks

[sunny_talwar]

I am working on a personal edition of QlikView, so I won't be able to open the file you have shared. I hope someone else might be able to help you better

Best,

Sunny

[#5]

Can anyone help me on this?