In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds:
In any hierarchy there is a parent-child relationship. Intuitively, the users' (and model builders) expectation is that in all UX interactions the parent dimension will be be sorted "on top" of its child dimensions. For ex., if the Department level in the product hierarchy contains 10 Classes then on the UX page when viewing both dimensions on the same axis the Department totals would be displayed first followed by the Classes.
This is akin the current 'Totals Position' feature. There are limitations to that feature as it seems designed more as a subtotaling feature and less like a hierarchy feature.
Secondly, the Show/Hide panel suffers the same counter-intuitive layout. Parents should also be above the children based on hierarchy. This would apply to, for ex., Department above Class in a Product hierarchy, or Month above Week in a Time hierarchy.
How often is this impacting your users?
Every day
Who is this impacting? (ex. model builders, solution architects, partners, admins, integration experts, business/end users, executive-level business users)
Model Builders - in trying to unit test, trying to communicate w/users, trying to run POC's
End Users - they regularly manipulate grids and perform show/hides; all users expect parents to be displayed before children; and regularly misinterpret their data because it is not structured intuitively; they often also spend unnecessary time researching why a particular number is
"wrong" only to discover they display issue.
Testers - has created unnecessary effort in validating data
Executives - they often have challenges reading report pages due to expectations around parent-child displays
What would your ideal solution be? How would it add value to your current experience?
The default sorting view would be parent dimension first then child dimension on every UX grid, in the Show/Hide panel, and anywhere else hierarchies are displayed. It would add immense value in terms of efficiency + savings of lost time + user acceptance.
Please include any images to help illustrate your experience.