2 Replies Latest reply on Feb 27, 2013 8:14 AM by Kim Hirst

    In my workbook I need to create 2 different date ranges for people buying a fitness pass and also filter one of the date ranges to show just one specific term

    Kim Hirst

      The data is looking at 2 years (ie 2011 and 2011) for pass sold effective date. I neet to show which clients bought a fitness pass of any term (ie, Annual, 3 Month, 1 Month etc) between July 1, 2011 and Dec 31, 2012 and renewed to an Annual term fitness pass between Jan 15, 2012 and Feb 15, 2012.  I would also need to get a total for the clients.

       

      Not sure how to do this or if it's even possible. The client is refered to by Barcode_number

      I've enclosed an extract sample.