Drill down

[#1]

Hi,

I'm busy with a pivot table, where I can drill down to the lowest level.

I already made something where the user can drill down by making a new group.

But when the user drills down on an item, the upper layer dissapears.

I just want a '+' symbol, that every level stays visible when you drill down.

Does somebody knows a solution for my problem?

Regards,

Tim

[SunilChauhan]

i am not getting you correctly but

i guess chart->properties->uncheck fully expanded option

hope this helps

[#3]

it's not working..

[khadeer]

I think u taken the dimension is group(cyclic or drill down), if u r taking group u can't get that option.

If u r taking 4(assume) dimensions, u can drill down that what u say, ......

else send me some sample data in Inline table. I will try.

[#5]

Here you can see an easy pivot table with my problem

When you drills down on Level1 => level2 is shown, but Level1 is gone

Regards

[Gysbert_Wassenaar]

That's not possible. What you could try is using more charts, one for each level, and show the lower level charts only if one item is selected in the level above. You can use expressions like if(getselectedcount(FieldX)=1,1,0) for the conditional display (under Show on the Layout tab of the charts properties screen). Change FieldX to the field name of the field you drill down in.