How to sort by a value for a axes combination in DataView
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.
Answers
-
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
1 -
Hi Björn, thanks for your reply. It's helpful.
0
