Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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/12 | 1/3/12 | 1/4/12 | 1/5/12 | 1/6/12 | 1/7/12 | |
---|---|---|---|---|---|---|
Expired | 10 | 25 | 152 | 15 | 23 | 240 |
Not Yet Expired | 12 | 75 | 897 | 100 | 199 | 188 |
Total | 32 | 100 | 1049 | 115 | 222 | 437 |
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?
hi,
You can use the pivot table. With expiry date as dimension and count of items as expression.
If you can have two expression for expired and Not yet expired. Or you have it as a field then you can add it as dimension.
You can drag the exipry date to get the result.
Deepak