Changing Dimension limits on drill down group

[#1]

Hi all,

I have a Drill Down group, and on it I have the Dimension Limits set to only show me the top 10 in my barchart.

Is there a way that the Dimension Limit can be disabled when I click and drill down to the next level?  So on the bar chart the first thing I want to see is the Top 10, but when I click into one of the items I do not want the next drill down item to be limited to 10 values.

Any way of doing this?

Thanks

[PradeepReddy]

try like this..

First create a drill down group 'Drill_Grp1' with the  hierarchy Country-->State. and then..

In dimension limits place the bellow expression and uncheck the 'show other options'

=if(GetCurrentField(Drill_Grp1)='Country',2,GetPossibleCount(State))

[#3]

Hi,

Sorry I am not sure I follow/can't get it to work.  I have made a file with some dummy data based on your example, can you show me what you mean?

Its just Dummy data so United States is the only country you can drilldown to that shows the states.  But in this example I want it to show me the Top 10 countries by Population, as it's doing now, but when I click into United States I want it to show me the population of all states not just top 10.

In my actual project I am working on my drilldown group is more than 2 fields if that matters -- but same principle, I only want the Top 10 on the initial chart, not any of the latter drilldowns.

Thanks for your help

[PradeepReddy · Accepted solution]

see the attachment...

Delete the second expression

=if(GetCurrentField(Drill_Grp1)='Country',10,GetPossibleCount(State))

In dimension limits tab, instead of 10, write the bellow expression

=if(GetCurrentField(Drill_Grp1)='Country',10,GetPossibleCount(State))

[#5]

wow, very cool, didn't know you could put an expression in that box.  Makes sense now, thanks!