This content has been marked as final. Show 7 replies
I am trying to create rankings i.e Top 25, Top 30 based annual sales with-in variance groupings i.e products, industry, etc....
However, the trick is getting the remaining customers as cumulative sub-total within the total (see table below)
I can create this in excel, I have created the result set within an sql if using oracle just cant get the aggregate function in Qlikview.
Any help is greatly appreciated.