2 Replies Latest reply: Sep 28, 2016 11:00 AM by Mark Ritter RSS

    selection

    Noha Salem

      Hi everyone,

       

      now I have sheet that compares between different data from different tables ... the problem is that each chart done doesn't see the selection made in the filter I have tried more than one way but it doesn't work

       

      so the filters is made using :

      Year([MasterCalendarDate.AllDateTime])

      Month([MasterCalendarDate.AllDateTime])

      Day([MasterCalendarDate.AllDateTime])

       

      the tables on the other hand has the following calculation in it :

       

      (sum (interval ([TechTimeLog.TechStopTime] - [TechTimeLog.TechStartTime])))

       

      note that in

      MasterCalendarDate.type = 'TechTimeStart'..................... was created by me in the master Date table so that the dates in the master date table that were pulled from [TechTimeLog.TechStartTime]  will have 'TechStartTime  ' in front of them in a separate columns

       

      So any suggestions