How to get a SUM of rows in a Pivot Table

[neena123]

Hello!

I can't seem to figure this out. I need a sum of rows in a pivot table. I am able to select sum of rows in a straight table but not in a pivot table.

This is the sum of rows I want:

I need a pivot table to have the same totals as above but don't know how to do it. 

Thanks!

[Anil_Babu_Samineni]

In Pivot table you need to select based on dimensions for each row from each dimension.

[sunny_talwar · Accepted solution]

Use Sum(Aggr()) functions

Sum(Aggr(Expression, arsalesname, entrydate, rewarddate))

[neena123]

Thank You! I was using the Aggr function but I did not include entrydate and rewarddate as well. Thanks!

[Brett_Bleess]

Hey guys, there is Help on this as well, just wanted to post for those that come here later and may have something that they cannot sort out, hopefully the Help info will do the trick in that case:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunction...

Regards,
Brett