In calculating running total, need to appear the cumulative total as at July in the total row

[nevilledhamsiri]

Dear Sunny

One more issue  am having which is how to present the cumulative total as at July in Total row. Once Aggr function is applied, it calculate the total of running total

Thanks

Neville

[nevilledhamsiri]

Dear Members,

Could any one help me on this?

Thanks

Neville

[Brett_Bleess]

Pretty sure you need the following to help you get it sorted out:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

The only other option would be to use RowNo() or RecNo() functions in the load to force every row in the pivot table to be unique at that point, which should then make  your totals equal as well...  Hopefully I am on the right track here.

Regards,
Brett