Keep consistent between Drill Down Group and Cyclic Group
I have a table with two groups, Dim1 and Dim2 are having same set of fields
Dim1 - Drilldown Group
Dim2 - Cyclic Group
I have a listbox to select Drill or Cyclic, based on that i will be showing particular dimension.
When user selects drilldown group and drill to next level, then if user changes selection to Cyclic in listbox, then the table changes to Cyclic dimension, but the cyclic group will have different field and drilldown group will have different field.
But i want to make both consistent.
When i drill into particular field using drilldown group, then even the cyclic group should have same field in cyclic group.