Intersection of cube view calculated rows and columns
Hi,
When creating a simple cube view using both calculated rows and columns, the intersection of these two formulas doesn't display correctly. Is there a way around this?
See attached photo where Variance and Variance % columns both show the value of the first cell instead of the difference and difference percentage as they do in the other rows.
Hi
There is a calc order within cubeviews, columns will be calculated first and rows will be calculates second. I assume, that this is the problem. The good thing: RowOverrides will be calculate third and ColumnOverides last.
I assume, if you move the calculation to the RowOverrides section of the column, it will work.
Keep us informed, if it solved the problem.
Cheers
