Sales by year
It seems we have sales information for all years together, but we want to focus on comparing years separately. To be able to calculate the current stock, you will first have to calculate the amount of items sold in 2021 and 2022 for each item.
We recommend you to keep working in your own workbook but if you lost progress you can open 1_4_revenue_and_profit_solution.twbx
from the Workbooks folder on the Desktop.
This exercise is part of the course
Case Study: Inventory Analysis in Tableau
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
