Sorting data view with multiple entites

Mark Schad

Hello, I have a dataview with two entities by row:

- Business
- - P&L Line

How can I apply a custom sort to the Business entity?  It only sorts by Code or by Description, and the Filter -> Sort in data view options only applies to P&L line.

------------------------------
Mark
Developer
Australia
------------------------------

Helmut Heimann

Hello @Mark Schad,

if you're using B11.3 you might want to check out the "custom sort" option on the entity members:

If you apply this to your entity Business you're able to get the items sorted the way you ordered them in the entity view by default.

The other members keep their original sorting order.

Kind Regards,
Helmut

------------------------------
Helmut Heimann
Senior Consultant
Board Community
Germany
------------------------------
-------------------------------------------

Mark Schad

Hi Helmut,

Thanks for your reply.  Unfortunately we're still on 10.6.  No way to do this in our version?

------------------------------
Mark
Developer
Australia
------------------------------
-------------------------------------------

Bettina Clausen

Hi @Mark Schad,

you can create an entity above the one you want to use in the axis.
Sticking to Helmut's example you would then have a tree looking like:

Product - Productgroup - Divison/Sparte - Reporting Division/Sparte

This new entity contains exactly the same elements as the one below. However, the entity above (Reporting Division) has the correct order of elements. So in your dataview you can use e.g. Productgroup and Reporting Division to have the order you'd like to show.

Best regards
Bettina

------------------------------
Bettina Clausen
Consultant
Board
Germany
------------------------------
-------------------------------------------