Forum Discussion
Product Count and Number Sold
I have Item SKU, Date Sold, Quantity Sold
The SKU is up to 90 different, The quantity is always 1
How do I calculate how many of each SKU I have sold?
You don't need to answer that prior to creating the single database covering all three years, however. The process that mtarler gives would apply after that database exists.
- WOW that works - THANK YOU very kindly for helping me.
I have created a Table with 3 years of data, how can I sort that to show data for each year instead of all 3 together?
Peter BowenIn addition to the suggestions by mtarler for sifting and sorting after making this data into an official "Excel Table," there are within Excel multiple ways to extract data for reporting by year (or other time periods). I mentioned the Pivot Table in an earlier post; that is a technique that many find VERY valuable for summary reporting. There are also many YouTube videos that show how to use Pivot Tables.
If the data you are working with are not confidential, you could post a copy on OneDrive or GoogleDrive, with a link pasted here that grants access. Then mtarler or I could offer more specific suggestions.
- i would recommend you 'Format as a Table' (Home -> Styles -> Format as Table)
This will default to adding the drop down quick filters that make it easy to sort and filter the set of data. You could just add those quick filters (Data -> Filter) but by formatting as a Table does more. For example when you select a cell in the table you have the Table menu and you can change the name of your Table. And you can reference all the data in the table using that name. So if you call it DATA and the first column is Date then DATA[Date] will refer to that date column.
