9 Replies Latest reply on May 17, 2018 4:40 AM by Zhouyi Zhang

    Show all columns (months) based on filter

    Charles Prodon

      Hello,

       

      I need to show all months in a table even when there is no data.

      I can achieve this by the Table layout -> Show empty columns; however this will show all columns from my data regardless of the filters I have defined on months.

      For example, I want to be able to filter on Q1 and show months of Jan, Feb and Mar with or without data (see enclosed workbook).

       

      Thanks for your help.

      Charles