3 Replies Latest reply on Jun 28, 2018 12:43 PM by Mavis Liu

    Show previous Quarter data based on the Quarter selected filter

    Nagaraj Koranthota

      Hi ,

       

      Requirement:

      I want to show previous Quarter data of the Quarter selected in the filter.

      Example:

      Fiscal Quarter is a filter in my dashboard and if I select Q4FY2018, I want to see data of Q3FY2018 for the measures available in the sheet.

      I am also showing the data of the selected Quarter from the filter but the requirement is to also show previous Quarter.

      This filter is dynamic as the user can select any quarter based on the available data

      I have 15 measures to show on a sheet and dashboard.

       

      Note:

      Data is at the Quarter level and stored in Fiscal Calendar.

      Attaching sample workbook and I have manually filtered in the previous Quarter sheet which has to be dynamic.