partial sum is showing wrong

[manjunaths]

Hi All,

I have five dimensions and one expression to calculate the sum of amount from a table.

When I select all the values from one dimension and  check the partial sum checkbox, the subtotal on top is showing wrong amount.  But when I export the same data to excel and calculate the sum, it will be different from Qlikview.

Thanks.

[jyothish8807]

Hi,

Try to check 'sum' of rows option.

Else you have to try with Aggr function.

[Colin-Albert]

In a pivot table you do not have the option to select whether the sum is calculated using the "expression total" or "sum of rows" as you do on a straight table. In a pivot table, the expression total is always used.

To get a sum of rows in a pivot table you must use the aggr() function with the pivot dimensions included in the expression.

Sum(AGGR(SUM(YourExpression),Dimesion1, Dimension2,....DimensionN))

[manjunaths]

hi colin,
Thanks for your reply.
I have used "Sum(AGGR(SUM(YourExpression),Dimesion1, Dimension2,....DimensionN))".
But still it is not working as expected. When I select individual field then amount is showing correctly. But when I select all the values in the field then it not showing amount against any of them.