2 Replies Latest reply: Feb 8, 2013 7:19 AM by kt_sesor RSS

    Compare data with previous day



      I would like to compare the data of the currently selected date with the data from the previous day.


      07/01/2012Jane ZDH344
      08/01/2012Jane ZED322
      07/01/2012Carol PPK123
      08/01/2012Carol PPK123



      I want a table that will only show the Date, Name and reference of the selected date. But I want to formatt the reference text if the reference changed from the previouse date. The table below shows how I want my data to look


      08/01/2012Jane ZED322
      08/01/2012Carol PPK123




      I havent been able to find a current disscussion on this that doesnt include set analysis and seeing as I am not performing aggregation to the Reference field I didnt think set analysis was appropriate for this.