11-03-2021 01:29 PM
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.
Solved! Go to Solution.
11-04-2021 07:15 AM
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
11-04-2021 07:15 AM
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
11-04-2021 04:02 PM - edited 11-04-2021 04:05 PM
Here's a slide that walks through the order.