Hi,
Please see the attached word document that has screenshots and explains the goal much more clearly.
Assume I have 4 Value Lists, each containing 3 items:
ValueList_A (contains A1, A2, A3)
ValueList_B (contains B1, B2, B3)
ValueList_C (contains C1, C2, C3)
ValueList_D (contains D1, D2, D3)
I create a Master View that has a grouping level of:
ValueList_A
-> ValueList_B
-> ValueList_C
However, I would like to have a different grouping for a specific item in the B list. Let's say item B2. For B2, I would like to insert the ValueList_D before the ValueList_C as a grouping level.
The end result would be a view that expands like this:
A1->B1->C1,2,...
A1->B2->D1->C1,2,...
A1->B2->D2->C1,2,...
A1->B2->D3->C1,2,...
A1->B3->C1,2,...
A2->B1->C1,2,...
A2->B2->D1->C1,2,...
A2->B2->D2->C1,2,...
A2->B2->D3->C1,2,...
A2->B3->C1,2,...
A3->B1->C1,2,...
A3->B2->D1->C1,2,...
A3->B2->D2->C1,2,...
A3->B2->D3->C1,2,...
A3->B3->C1,2,...
I've tried doing this using the 'Customize' option on the B2 virtual folder, but the problem is there are *many* B2 virtual folders:
A1->B2
A2->B2
A3->B2
etc...
Each one needs to be customized individually, which is not possible if the user can add values to the ValueList_A list.
Any guidance would be appreciated.
Thanks,
Chris