If you are running a business and wants to see how much do you sale and what is the breakup and effect of each product on your profits, this post is for you!
Whenever you have sales data, it is always required to get some meaningful reports from it. This could be finding the product wise total sales, monthly sales volume, year over year sales of a product, profit margins from each products and much more.
Today will see how we can setup a spreadsheet to find such parameters to make reporting easier.
We will start with a sales database (you can see the companion sheet) and extract some relevant information from it!
In What category we the most volume sold for year 2012?
In this report we have 16 Categories – but we want to find the one that had highest sales in 2012. The task can be achieved by setting up column enlisting all the categories and putting up this formula (assuming the categories in Column A)