Matrix visual sorting issue

[ykannan]

Hi Friends,

I have a matrix where I showing Growth% for 2 different Types. I gave given descending option for this column. Can any one explain how the sort works? If you see below, 130.1 should come in the top. but in the other categroy it has a negative value. So some how system understand differently and placed in between 39.7 and 34.0.

Just tried following to understand, in case, but not worked.

If I sum both, it is 45 (130.1 - 85.1), it should have been placed between 50.7 and 39.7.

Please help understanding the sort in this scenario

Below is the Matrix visualization properties,

Growth% =  DIVIDE([Sales Amount]-[Prev Sales],[Prev Sales])*100

[v-chuncz-msft]

@ykannan 

You may check column subtotals and use Performance Analyzer to check query.