1 Reply Latest reply on Mar 16, 2017 1:21 PM by Lisa Li

    Dynamically Hide Null Columns

    Todd Moses

      I've got a crosstab with dynamic row headers.

       

      Based on the user's selection, they either get "B" values as the first row header and Null as the second row header, or "A" values as the first row header and "B" values as the second:

       

      A>>B

      B>>Null

       

      Is there a way to dynamically hide the null row header so that I'm not left with a blank space in my crosstab?

        • 1. Re: Dynamically Hide Null Columns
          Lisa Li

          Hey Todd,

           

          You can try rebuilding your dashboard so you only drag one field onto the view.

           

          Assuming you're using a parameter (I'll call this [user selection]), build a calculated field off of the parameter.

          If [user selection] = "A Values" then [A Values]

          elseif [user selection] = "B Values" then [B values]

          end

           

          If that doesn't work, your data is probably architected differently than I expected. Would you be able to upload your dashboard with dummy data perhaps?

           

          -Lisa

          CoEnterprise | Home