Forum Discussion
Matrix Row Hierarchy Showing Incorrect/Excess Information
I have a matrix with a 2 level hierarchy. (Account>Shop). I'm using some tricks I learned from others to control the column headings (it has its own table with two fields display name and sort order) and the data that is displayed. I then have two related tables which I'm using to filter the data.
The issue I am seeing is that all the shops are displaying under each of the accounts. Only data for the shop associated with the account is displayed, so I have a bunch of unneeded rows displaying.
2 Replies
Hi Anonymous
I am going to go out on a limb here and say that the tricks used in the Header table are impacting the relationships that have been established in your data model. By using the Header table columns (instead of the Account Name from the Account table and Shop Name from the Shop table) you are telling the Matrix table to include ALL Shops and ALL Accounts because there is nothing to manage the relationship.
If you can use the Account Name from Account table and the Shop Name from Shop table, you should fix the problem.
Hope this helps!
Theo
Theo,
The tricks are to control the column names and their sort order. It also ensures the data under the columns match that information. The columns and data under those columns is good and responds to filters without issue.
The rows are not changed in any way. I have Account shown first and Shops below them:
