9 Replies Latest reply on May 1, 2018 9:50 PM by Zhouyi Zhang

    Dual date filters across blended data sources

    Geneth McAlister

      Hi,

       

      I need to create the following chart on my dashboard:

      It needs to be able to do the following:

      1. Select the Plan End Date
      2. Select the end date for actual sales (Sales End Date)
      3. Select the number of periods that you want to view (Sales No Periods)
      4. The Plan Date Range must run from the Plan End Date back for the number of periods selected
      5. The Sales Date Range must run from the Sales End date back to the first of the month for the Plan Start Date

       

      This is all fine except I don't know how to filter for both the Plan Date Range and the Sales Date Range at the same time.

      I have attached an example packaged workbook by way of example.