Conditional Show Issue - Straight Tables

[wonkymeister]

Happy Monday!

I have a straight table with a drill down as a dimension. The Drill down dimension has 4 levels – Faculty, Division, Course and student.

Once the user reaches the 4^th level by drilling down through the dimension to Student, I want to change the table that is displayed (I want to display different columns at the Student level as opposed to the original columns displayed at the Faculty level)

Now obviously if I was using selectors outside of the straight table it would be easy, just using GetSelectedCount etc

But I’m not – nothing outside of the chart is being selected, only the dimension itself from within the table

So my question is, how can I make my table disappear and another appear when the user drills down to the lowest level in the dimension? (i.e. conditional show)

Thanks in advance

Wonky.

[Gysbert_Wassenaar · Accepted solution]

You should still be able to use getselected count. The drill downgroup constists of fields. By drilling down, you make a selection in the current field in the group and the chart drills down to the next field in the group. If you add listboxes for the fields in the drilldown group you will see that values get selected. So, using the getselectedcount function should work.

[luciancotea]

Use this in conditional show for the Student Detail table: = if( only(Student), 1 , 0)

Use this in conditional show for the All Students table:     = if( only(Student), 0 , 1)

[wonkymeister]

Of course it does, i'm being a total idiot

Sorry and thanks fellas.

Monday morning idiocy, more caffeine required