Variance Analysis in Cube View
I'm working on a cube view that does a variance analysis between 2 difference scenarios. The scenarios will always vary based on the scenario member selected by the user.
Some of the rows use the f...
Forum Discussion
Hello!
Yes, there's an issue that you can't use formulas in both rows and columns. Per OS support from an old ticket I submitted:
You are still not able to use a GetDataCell on both a row and column in either a quick view or a cube view.
Your best option is to create a cube view (which can be opened in Excel) and use row or column overrides to get at what you need. Or you can use cube view math to get your variance.