I have a crosstab with this structure (year, quarter, month columns) (see attachment)
Based on which column group is expanded I want to show a different value in the yellow field.
- if the Year column is collapsed I want to show field1.Value
- if the Year column is expanded I want to show field2.Value
- if the Quarter column is expanded I want to show field3.Value
I tried using scopes but I the scope doesn't exists I get an error. So in case the Year column is collapsed I get an error that the month scope doesn't exists.
Is there a function to check if a certain scope does exists?