4 Replies Latest reply on May 10, 2018 11:09 PM by NIAN ZHANG

    Get Previous year count distinct

    NIAN ZHANG

      How to get the measure for FY 2017  when FY2018 is selected in the filter ? I would like to show the measure for both FY2018 and FY2017 on the same view ideally (with FY2018 is selected in the filter).

      what I want to achieve is to show the COUNTD(newstudent) for FY2017, while FY2018 is selected in Year filter . I want to show just the number, no other dimensions in the view. This view will be used in a workbook to show previous year (FY2017) measure, alongside with current year (FY2018) measure. 

       

       

      Capture.PNG