When a Column Calc and a Row Calc Intersect, which one does Analysis choose?
Product: BI 4.0 SP8.3
Database: MS SQL Server 2012
I have created a Total column (last column on the right) that contains a calculation that Adds the values of all the columns before it.
I have created a Gross Margin % row that contains a calculation that does a Percentage Share between two specific columns above it.
As can be shown in the screenshot below, Analysis looks to be confused when it comes to choosing which calculation to perform when the Total column and the Gross Margin % row intersect. I want it to perform the Gross Margin % calculation, which would have resulted in "66%". Unfortunately, Analysis displayed the number "10", which doesn't make sense:
How can I tell Analysis to perform the Percentage Share calculation and not the Addition calculation?