Intersection of cube view calculated rows and columns

[MMclean]

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.

[ChristianW · Accepted solution]

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

[ajslack]

Here's a slide that walks through the order.