6 Replies Latest reply on Dec 12, 2017 4:07 AM by Steve Y

    Is there a way to filter a specific date and date range using a single filter?

    Steve Y

      Hi,

       

      Is there a way to filter a specific date and date range using a single filter?

       

      Sheet 1 shows profit ratio of a single month(latest month as default)

      Sheet 2 shows sales from 1st date to "filter date".

       

      If I select Sep 2016 in the filter, sheet 1 should show Sep 2016 profit ratio and sheet 2 should show Jan 2014 to Sep 2016 sales. However, I can only do it by setting 2 filters, is there a way to solve it with only 1 filter?

       

      I cannot use date parameter for the case because parameter is not dynamic (newly input data will not be shown in the parameter).