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:


      Not Yet Expired1275897100199188


      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?