Job Requires using a already created pivot table in excel.
We require all data to be sorted by categories. Then within each category we need the data put into summaries comparing:
- Monthly comparisons
- Seasonal comparison
- Annual comparison
All summaries, must include:
We need to be able to look at the data summaries and demonstrate:
- the rankings of the products in that category - By revenue or QTY
- the top supplier for the month - By revenue or QTY
- the items that sold the most units for that Period - month, season, year
Also if you feel there are other summaries we can create to analyze the data, we will consider that as well.