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?
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)
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..
.png "Former Employee"){kind=icon}
