AnsweredAssumed Answered

How to sort by a value for a axes combination in DataView

Question asked by kevin.wu on Jul 11, 2019
Latest reply on Jul 12, 2019 by kevin.wu

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.

Outcomes