10 Replies Latest reply on Feb 19, 2020 12:40 PM by Aaron G

    Display Columns based on Current Month or Month Selected

    Aaron G

      Hi All,

       

      I'm trying to display a range of columns in the table visualization (All Feb columns) based on either A) the current month or B) the month selected from a dropdown menu.

       

      I'm getting stuck using the calculated field to determine which columns to display. Any help would be greatly appreciated. I've provided an example table below for reference.

       

      TeamResourceJan - SummaryFeb - ActionFeb - DeltaFeb - ForecastFeb - ActualFeb - Summary
      Team 1Resource 1100001
      Resource 2111012
      Team 2Resource 1001100