Forum Discussion
Matrix : hide lowest level rows
DirkVr Thanks, that is helpful. So, if I am understanding things, sometimes the Level 2 might be location and sometimes it might be subregion? Is that correct?
That is correct
DirkVr There might be the answer to the issue. Your hierarchy is not what I would call a "proper" hierarchy. Would it be possible to reformat your data into a proper hiearchy where Level 1 is always Region, Level 2 always Subregtion, Level 3 ??? and Level 4 is Location?
Then you could simply put Level 1 and Level 2 into your matrix as an informal hierarchy and the problem should be solved.
That is an issue. I am working in a multi-tenant environment where each tenant has its own hierarchy structure. Some tenants have 1 region and below that several locations. Other tenants have 1 region, subregions. Below subregions, that have locations and sublocations.
Hi Greg,
You inspired me :-). I am working now a solution where I have 2 hierarchies. 1 for the regions, and 1 for the locations. I hope this will help 🙂