Right now I have a chart with expression of "sum ({<YYYYMM={">=$(=$(vMaxYYYYMM)-100)<=$(=$(vMaxYYYYMM))"}>}Sales" to show last 12 months sales. May I know is that possible to create an expression to show month over month change over last 12 months.
I tried " sum ({<YYYYMM={">=$(=$(vMaxYYYYMM)-100)<=$(=$(vMaxYYYYMM))"}>}Sales - sum ({<YYYYMM={">=$(=$(vMaxYYYYMM)-101)<=$(=$(vMaxYYYYMM)-1)"}>}Sales", but seems not working. And as the data source was not a straight table, I guess ABOVE function will work easily.
