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

Previous Member

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.

Björn Reuber

Hi,

 

there are several wishes on this area. I think best fitting would be:

Enhance the DataView Layout SORT function 

 

Please also read the answer, why a request like this isnt easy to solve (on a general way)

 

regards

Björn

Previous Member

Hi Björn, thanks for your reply. It's helpful.