drill-down groups

[#1]

hi,

i have this pivot table (full Expanded)

  

i've made a drilldown group with this same fields and it works fine but when i select "Centro" it goes directly to "Sub-Segmento", i think it's because there's only one choice "Maria".

How can i show this choice and avoid to go directly to the 3rd drill-down Field.

tnks

[Anonymous]

check your drill down group order...it should be Regional, Jefe de Zona and Sub-Segmento.

assuming you have it that way, it is weird that it only works that way with centro. what happens with Sur? Sur has only one value/choice as well.

[#3]

hi, you are correct i take Centro as an example to the question but it happens with the "Sur" too.

[Carlos_Reyes · Accepted solution]

It is working as designed... Review these similar discussions:

RNAM - Topline is shown in my drilldown structure

I notice in drill down it is bypassing one level of hierarchy.

[Anonymous]

Hi Carlos,

it is the standard behaviour for drill down groups, if there is only one value for a level this will be skipped.

[#6]

tnks

i use your conditional code:

For the top field:

      getselectedcount( TopField )<1

For the next field

      getselectedcount( TopField )=1 and getselectedcount( NextFieldName ) <1

For the third field

      getselectedcount( TopField )=1 and getselectedcount ( NextFieldName ) = 1 andgetselectedcount( ThirdFieldName ) <1