Highest level drill down group

[rudywelvaert]

Hi,

I made a drill down group with 4 levels:

highest level: Organization

second level: Region

third level: Team

lowest level: Team member

The question is: Why can't I get to the highest level in the drill down to show the total for the whole organization.

I can only go to the second, third and lowest level.

I attach a simplified example Drill_Down_Group.qvw

Thanks for any help

RW

[m_woolf · Accepted solution]

This is from the Ref Manual:

When a drill-down group is used as a dimension in a chart, the chart will use the first Fields (page 167) in

the group's list of fields that has more than one possible value. If selections are made that cause the field to

have only one possible value, the next field in the list will be used instead, provided that it has more than

one possible value. If no field in the list has more than one possible value, the last field will be used anyway.

If you change to a Cyclic Group it will work.

[rudywelvaert]

Thanks m w

That is what I suspected.

I tried the cyclic group and it works.

Thanks again

RW