RNAM - Topline is shown in my drilldown structure

[#1]

Hi Everyone,

I am creating a drill down group with RNAM being the top drill and then company follwed organizations and so on.

I notice RNAM is not shown in my chart, it displays starting with company even though RNAM is the first level in my drill down group

any inputs on why RNAM is not shown and any suggestions on how to get RNAM shown in the drill down chart,

appreciate your help on this

[Gysbert_Wassenaar]

If the RNAM dimension contains only one value then the values of the next level down will be shown instead.

[phaneendra_kunc]

Does you RNAM has only one value (Data)?

[#4]

Thanks Gysbert, it makes sense

[#5]

yes, it has only RNAM in the entire data

[#6]

I have actually tried changing few values in the top line then it seem to show.

But my question is , my previous teammates already did the same chart for a different division , in that RNAM is shown even though contained only RNAM in it.

[phaneendra_kunc]

That is the default behaviour of Drill Group.

Change it to Cycle Group and it wont skip if that column has single value...

[#8]

Hi Phaneendra,

That works , but when I click on RNAM it would nt let me drill down , I need pick it up from dropdown to look into the drill down, is there way out of this, ?

[phaneendra_kunc]

There is no way...Only way is its a two step process...You have make a selection and cycle trough and select your desired dimension.

[Carlos_Reyes]

It's not ideal and will be confusing but you can use the Enable conditions box on each field that composes the drill down group. So, you add all the fields in order as dimensions, for instance, RNAM at the top, the next field and so on...

Then you place the following expression in the Enable conditional box. You'll have to change the field name accordingly:

For RNAME or 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 and getselectedcount( ThirdFieldName ) <1

and so on....

The drawback with this method is that you'll need to select only one value on each field in order to show the next level...

I think that the default Drill Down or Cyclic groups are the best options... It's just a matter that the users get used to it.