Parallel hierarchical lists
Hi all, could you help me how best to structure a parallel hierarchy list that we need as part of our ongoing business analysis. Here's the construct that I'm looking at.
At the bottom level we have Clients that we need to be able to aggregate by different attributes. These attributes are:
Client: Client 1, Client 2..... Client 10
Geography: Geo 1, Geo 2
Model: Model 1, Model 2
Category: Category 1, Category 2, Category 3
Status: Status 1, Status 2
I thought about creating flat lists with all of the above, but the issue is that with multiple parents for the same item (i.e. Clients), I can't get auto aggregation at various levels. Would greatly appreciate if someone could advise on the best way to get this done.