As shown in the screenshot below, we have a Sales cube and Budget cube, which have the same dimensions - Item, Area, Month, UoM. We tried to calculate the Severity (i.e. bias) and present the data in a flatten dataview showing Severity in descending order so we can find the most problematic Item/Area combinations as shown in the screenshot 2.
However, when we added both item and area in the row axes, the dataview shows data sorting by Items first then Areas, rather than taking item/area combination as a whole. Is there a way we can sort by the Severity and show the corresponding item/area combination? Thanks.