3 Replies Latest reply on Mar 6, 2016 8:37 AM by Mosin K

    How to restrict our data across data source based on date

    Randy Adhitama Setiadi

      Hi All,

       

      I want to ask is it possible to show only KPI until certain date that only showed. And I need to do this across different data source.

       

      Here's the example. Let say I have 2 data source:

       

      1. Sheet 1

      2. Sheet 2

       

      Sheet 1 contain data that records survey that certain person did. And noted that 1 person can fill the survey more than one.

       

      I only need the last date for every PersonId, so icreated a new calculated field called "Last Date Show"

       

      Now go to sheet 2, Sheet 2 contained data with certain KPI data.

       

      Every PersonID in Sheet 2 have their performance on certain day. I don't have idea how to make it restrict based on the last date they filled the survey on the Sheet 1. So it will something like this.

      * don't bother with EventID, I only created it to show how the data should be.

       

      So, how I can make the data it Sheet 2 restricted based on the last date data in Sheet 1?

       

      Attached is workbook example

       

      Thanks

       

      Randy