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.
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.
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.
