drill down issue

[NavinReddy]

Dear Experts,

I have an issue

I created drill down ,when i added this in to chart its not working

I have 4 levels,directly its applying level2 in chart

i am not getting level1 in my chart ,its showing directly in level2

Please some one help me

Thanks In Advance

Niranjan

[JonnyPoole]

It could be that only 1 value is in the top level , or your current selections have filtered it down to 1 value.

Drill down groups will auto-drill down when there is only 1 value... just as if you clicked the 1 value to drill down.

[giakoum]

is there data for level 1? A sample application would help.

[NavinReddy]

Hi Jon,

I agree but in middle also its giving problem,

Acct1,Acct2,Acct3,Acct4

But in this im not getting Acc3,its going directly Acct4

Any Suggestions please

Regards,

Niranjan

[JonnyPoole]

it would be the same behaviour whether its a single value in the top or middle, it will auto-drill to the level beneath until you encounter a level with more than 1 value, or you reach the bottom. 

is this consistent with what you are seeing ?

try creating a pivot table with the 4 levels and checking that your drill path you are testing has 1 or more values where it appears to jump an extra level (or more) down.

[NavinReddy]

Hi,

Please find the sample application

Regards

Niranjan

[giakoum]

Your group was in the wrong order (see attached app);

[JonnyPoole · Accepted solution]

So if you drill on 'allocations out' in 'Account rollup 3' it will jump straight to Acct 3 because the 2 levels between just have 1 value

[christian77]

Hi.

I don't like drill groups. You all know why.

Use a cyclic one instead.

Good luck.

[NavinReddy]

Hi,

Again Im getting same results only

any other ideas

Regards,

Niranjan