4 Replies Latest reply on Jun 14, 2018 10:06 AM by Vinnie Ahuja

    Need to filter and summarize # of days with less than x # of rooms

    Renelle Risley

      What is the calculation for filtering and summarizing data by a criteria.  The data looks like this:  I need to state that during the month of May, there were 4 rooms with only 2 items.  (Eventually, I need to roll this up to a yearly total).  I think it's a level of detail calculation but I cannot get it right.  Thank you for your help.

       

       

       

      Date# of Rooms
      1-May2
      2-May3
      3-May2
      4-May3
      5-May2
      6-May2
      7-May3
      8-May3
      9-May3
      10-May3
      11-May3