I have one tough situation in developing a qlikview dashboard, that is how to calculate sales of New York in the past months? Please find the sample data below:
City
Month
Sales
Avg Above Sales
NewYork
2013/7/1
1000
1000
NewYork
2013/8/1
1200
1100
NewYork
2013/9/1
1500
1233.333333
NewYork
2013/10/1
2000
1425
NewYork
2013/11/1
3000
1740
NewYork
2013/12/1
1800
1750
NewYork
2014/1/1
1200
1671.428571
The last column, always calculate the average sales amount from 2013-07-1 to current month.
I really have no idea, can you please help on this? Many thanks.
