1 Reply Latest reply: Jul 19, 2012 2:05 AM by Deepak Kurup RSS

    Pivot Table With Dates As The Fields?

      What is the best way to go about making a pivot table that will display dates across the top, and a count of the records below it?  I have a set of data (that changes daily) that contains the UPC of an item, and it's expiration date.  For each day, I need to show the count of items that are past/have met their expiration date, and the count of items that an expiration date in the future.  It would look something like this:

       


      1/2/121/3/121/4/121/5/121/6/121/7/12
      Expired10251521523240
      Not Yet Expired1275897100199188
      Total321001049115222437

       

      In the raw data, it's just a UPC and an expiration date.

       

      Or, am I going about this completely the wrong way?  Could a straight table with expressions do this?