It's hard to be clear so I'll try to explain with a concrete example.
I need three grids. Category, Sourcing and Service. I need to display them at the same time with all the related data but I also have to allow users to filter the grid. Each grid should be filtered by others grids. Here is some example of what should be answered by these grid :
- What is Sourcing distribution by Category ?
- For each of theses Sourcing, what's the Services distribution ?
- What is the Category distribution by Service ? By Sourcing ? Etc.
It sounds like Excel pivot table and I don't know how to create an understandable UI.
I tough about a grid imbrication hierarchy but I don't know how to change the parameters when I expand each line.
The readability of this kind of grid is poor and I don't know how to change properly the order of the grids (Client -> Order -> Product, to Order -> Product -> Client or Prodduct -> Client -> Order, etc.).
Do you have some ideas in order to answer to this problem ?