[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5460.AGGRExample.doc:550:0]I have a pivot table that show SUM(Qty) by YearQuarter and WeekInQtr and would like this data to show the cummulative by Week within th the Quarter
AGGR (NODISTINCT SUM(Qty), YearQuarter, WeekInQtr)
For some reason It will work fine for YearQuarter and also by WeekInQtr but will not work correctly for YearQuarter,WeekInQtr
I have attached a sample of the pivot - I want the total units to show cummulative by Week/Quarter down
Any help would be appreciated.
Thanks
Graham