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


      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 :





      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