Question: Is it possible to sort the product by the account data value “Sales” and have the product with the greatest sales first etc.?

[OSAdmin]

Question (Cont)

A Cube View was created which has a row defined as S#ACT “Actuals” and a Column defined as U1#Product.Children. An Advanced Chart was created with the Diagram Type = XY2D, Swap Axes set to True and Type is Bar Stacked. Otherwise, defaults are selected. The Advanced Chart was added to a dashboard and the products display on the Y axis in member order.

Answer

It should be possible to sort Products by Sales to display the products with the greatest sales first utilizing our XFR_MemberListRanked business rule, which is attached. Our example uses Customers in UD4 but can be used with any UD dimension like Products.

Question Follow Up:

How do you see the total for the ranked list?

Answer:

Use a dynamic aggregation in the cube view itself. Adding up the rows or columns.

 Source: Office Hours 2019-11-26 Partner Enablement