Sorting data view with multiple entites

Mark Schad
Mark Schad Customer
Fourth Anniversary 10 Comments Advocate 5 Up Votes
edited October 2020 in Platform
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
------------------------------
Tagged:

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    250 Likes Fourth Anniversary 100 Up Votes 100 Comments
    edited November 2020
    Hello @Mark Schad,

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


    image


    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.


    image


    The other members keep their original sorting order.

    Kind Regards,
    Helmut

    ------------------------------
    Helmut Heimann
    Senior Consultant
    Board Community
    Germany
    ------------------------------
    -------------------------------------------
  • Mark Schad
    Mark Schad Customer
    Fourth Anniversary 10 Comments Advocate 5 Up Votes
    edited November 2020
    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
    Bettina Clausen Employee
    Fourth Anniversary 25 Up Votes 25 Likes 5 Answers
    edited November 2020
    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
    ------------------------------
    -------------------------------------------