# When a Column Calc and a Row Calc Intersect, which one does Analysis choose?

Hi,

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?

Cheers,

Michael