4 Replies Latest reply on Jan 14, 2019 3:04 PM by Relevant

    Fill in Empty Columns And Filter

    Zhaoyang Jiang

      All,

       

      I'm working with some date data and want to fill in the blank column but still able to filter it.

       

      Attached is an example workbook.

      I can use the Analysis -- Table Layout -- Show Empty Columns to show the months that don't have data (April and June).

      But then the date filter doesn't work. I can filter out the data but the X-Axis stays the same.

       

      How can I filter the X-Axis to start from May?

       

      Any help appreciated!

       

      2.png