Hi I am new to Qlikview.
How to calculate past 3 months total sales in strightable for each month.
Thanks & Regards
You have to order the dimension correctly first.
This will work after you sort:
Above (Sum(Sales) , 0 , 3)
If I mention total in front of sum is working. may I know the reason for this?
this can help
Calculating rolling n-period totals, averages o... | Qlik Community
Retrieving data ...