drill down group expressions

[alec1982]

hi all,

I am trying to build a dynamic drill down group of 10 levels (Dimensions).. I want to show different expression based on the dimensions the user is on. for example if the user on dimension 1 the expression will be count items, if the user on dimensions 2 then the expression is sum amount then if if the user drill down to dimension 3 the expression will be sum of shipping amount..

the above is doable by using GetCurrentField(group_name)..

One thing that I am trying to do is to ignore a dimensions if there is no value for it.. for example, if the user is on dimension 1 and then within the data dimension 2 has nothing then when the user drill down he/she will be pushed to dimension 3.. any idea how to make that?

[JonnyPoole]

i think thats the default even when there is just 1 value in the intermediate dimension.  Is that not the behavior you are seeing when you drill down from dimension1 ?  (and there is zero or just 1 value underneath)

[alec1982]

for the major part yes.. but when it reach the last available level such as Level 3 then I click on that bar, it shows no data to display while I want it to stay on the last available level..