1 Reply Latest reply on Mar 3, 2016 6:36 AM by Shinichiro Murakami

    Show/Hide Dimension Using Parameter

    Matt Parkin

      Hi there,

       

      I've created a couple dynamic dimensions for my table that change according to what the user selects. When the user selects 'OVERVIEW' my table that looks like this:

      Capture1.JPG

      However, when I select something else from the parameter, that only requires one dimension to be displayed, it looks like this:

      Capture2.JPG

      What I would like is for VIEW 2 to be completely hidden from the table when anything other than OVERVIEW is selected in the parameter. My code for VIEW 2 is simply:

       

      IF [View Parameter]="OVERVIEW" THEN [Original Result]

      END

       

      Is this something that can be done? Or will I have to create a seperate sheet for the Overview?

       

      Thanks.