Sorting data view with multiple entites
Mark Schad
Customer
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
------------------------------
- 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:
0
Answers
-
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
------------------------------
-------------------------------------------1 -
Hi Helmut,
Thanks for your reply. Unfortunately we're still on 10.6. No way to do this in our version?
------------------------------
Mark
Developer
Australia
------------------------------
-------------------------------------------0 -
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
------------------------------
-------------------------------------------0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP