Variance of key figure in same column as an adjocent column in BEx query
I have a requirement to show the variance of particular key figure as an adjacent column in a query. I am using this query in SAP Design Studio and will enable exceptions in the variance column.
PFB example. I would like to have 12 month data like this with the variance from previous month as next column. (for Feb, 105-100=5)
I can't fix each month value in a key figure structure since its not useful for me in SAP Design studio. I think, with fixed KF structure, its possible by cell reference. Any possibility to achieve this by defining a formula with exception aggregation as variance? I get values only in total when I try that.
Please suggest some solution. Its urgent and quick response would be highly appreciated.
thanks in advance