Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Variance of key figure in same column as an adjocent column in BEx query

Hello All,

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


Nikhil Joy

Not what you were looking for? View more on this topic or Ask a question