1 Reply Latest reply on Nov 15, 2013 8:44 AM by Eric McDonald

    How to make table show different columns when filter changes?

    Tara Carter

      Hi there. I need to create a table with these columns: KPI, Goal, % Goal, YTD, Month1, YoY, Month2, YoY, etc. Filters are Industry, Campaign, and Month.

       

      when a Campaign is selected, show KPI, YTD, Month1, YoY, Month2, YoY, etc

      when none Campaign is selected, show KPI, Goal, % Goal, YTD, Month1, YoY, Month2, YoY, etc

      when date filter selects any month last year, hide YTD, Goal, % Goal, YoY columns

       

      Is it possible to create such a table? Thanks a lot.

        • 1. Re: How to make table show different columns when filter changes?
          Eric McDonald

          Option (1)

          You can create a custom parameter with Filter values: Industry, Campaign, and Month

          Then can create calculated fields to hold metrics and use a case statement to display the value in each one based on the parameter value

           

          Option (2)

          Create parameter as above.

          Create 3 separate views full screen and switch them using a vertical slider with a view in each panel. Demonstrated at European Conference in London but can't remember how