7 Replies Latest reply on Oct 30, 2018 9:02 AM by Don Wise

    Filter Help  (2018.2.3)

    James Hardin

      Hi!  I hope I have what is a simple issue,  I just can't wrap my head around how to fix it,  or google foo the answer.

       

      I've attached a sample workbook.  I am looking at room use over multiple days.  What i would like to do is use a filter to look at any rooms who's use on Monday is below 10 hours.  I cannot simply use a "Hours Used" quick filter, because I don't want to filter out the Tuesday results.

       

      My question to answer is basically,  "If a room is used 10 hours or less on a Monday,  how many hours is it used on Tuesday?"  (full data set has hundreds of rooms)

       

      Can this be done with a calculated field,  parameter, or combination of both?

       

      Thanks!