Hey guys,
I've been tackling this issue for a while. Basically my data source is some inventory data, which has two dates (in year) for when the product was made, which factory it was made in, and when it was sent out. So a typical entry would look like this:
I have a pivot table that illustrates the data from this data, and I want it to have the year, the count for the number of products made, and then the count for the products sent broken down by year and factory. So, something like this:
The problem is, I've set most of the table based on the "Year" being the year made, so when I try to do the Count o sent, I can only look up what was made in the year. Anyone have a good idea for this? Thanks in advance.
Bookmarks