Group within a Group?

[danielact]

I have a report that uses a drill-down group. I was asked to replace one of the fields in the drill-down with a choice of three. If it was only those three, with nothing before or after it, I'd just set up a cyclical group. Is there a way to set up a cyclical group to be used as an element within a drill-down?

[kaushiknsolanki]

Hi,

   Its not possible to have group within group.

   I dont know is this meet your requirement or not, but if you have only one expression in chart then you can use the two dimension. one as cyclic and other as drill down.

regards,

Kaushik Solanki

[danielact]

I have a lot of expressions in the chart, and I don't want to have the full split by each one. I want to have the drill down go Level A --> Level B --> Choice of [C1, C2, C3] --> Level D

[kaushiknsolanki]

Hi,

    Is C1, C2, C3 Are fields.

Regards,

Kaushik Solanki

[danielact]

Yes, they are fields. I'd put them in the drill-down separately, but I don't want to have to filter one to get to the other.

[kaushiknsolanki]

Hi,

    No its not possible to implement group within group.

Regards,

Kaushik Solanki

[#7]

I just posted this in response to another question but thought it may be helpful here also with a little tweaking:

You can add calculated dimensions to a cyclical group. Just click the 'Add Expression' button under the 'Used Fields' box in the Group Settings box.

dimension 1: Level A

dimension 2: Level B

dimension 3: if(Level C= 1, 1, null())

dimension 4: if(Level C= 2, 1, null())

dimension 5: Level D

Then in your dimension settings check the 'Suppress if value is null' box to limit it to show only those values for the appropriate Level C.