2 Replies Latest reply on Jun 14, 2018 10:52 AM by Harjeet kaur

    How to show Past and future data in one table

    Harjeet kaur

      I have a data set that has a ID column and two date columns one is the past appt and the other is future appt.

       

      Right now i have 3 different sheet that show how many appt an ID has in the next four weeks and another sheet with how many appt they had in the past 4 weeks and a 3rd sheet that has grand total of all future appt after the initial future 4 weeks.

       

      what i am looking for is how do i put all this in one sheet as i dont want to have to scroll down multiple sheets. I have attached my workbook below