Show different field based on expanded groups in a crosstab

1 posts, 0 answers
  1. Marcel
    Marcel avatar
    21 posts
    Member since:
    Jun 2008

    Posted 14 May Link to this post

    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?

     

     

     

     

Back to Top