Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a issue to display cumulative sum in pivot table.Now am using the expression as
Iam not getting the Total Value for columnname Cumulative in the attached pivot table.So,Kindly all help me to solve this issue.
Thanks & Regards
In your expression, you are explicitely returning 0 for your total line (dimensionality() = 0).
Instead, try using a sum-of-rows-in-pivot-table expression (check the HELP for more details, there is a whole chapter that covers that).
It would probably look similar to
sum( aggr( YOUREXPRESSIONCOLUMN1, Location, Month) )
where you need to replace YOUREXPRESSIONCOLUMN1 with the appropriate expression and double check your aggr() dimension field names.
It works fine.The third dimension dragged into vertically alignment.The cumulative total gives correct result.Incase the third dimension dragged into horizontal alignment.The total become 0.