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 Expired||12||75||897||100||199||188|
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?