Create an average of current month and previous month in same column.
I’m trying to create a measure that is the average of the current month and the previous month. For example: if the sum(Sales) for Oct2015 is $1,000 and the sum(Sales) for Nov2015 is $2,000, I want value in this new column to be $1,500 for Nov2015. Likewise, the values in this column for the previous month, October, will be the average of Oct/Sep…and the value for the September row will be avg(Sep/Aug), etc.
Is there a formula for Qliksense that will allow me to create this dimension in the table? Might it have to be done in the script? If so, how?