Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
hi, you are correct i take Centro as an example to the question but it happens with the "Sur" too.
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.
Hi Carlos,
it is the standard behaviour for drill down groups, if there is only one value for a level this will be skipped.
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