This week’s #workoutwednesday was about comparing last 2 periods sales for a sub-category using date functions with customize tooltips.
Requirements
- Dashboard size should be 1000×600.
- Sub-Category on the Rows Shelf, and Year of Order Date on the Columns Shelf
- There are 3 measures, Sales, % of Total (in year) and % Difference
- Only the Sales Measure has color (which colors you use don’t matter, just that Sales is the only measure colored).
- Users can select a Year and a Measure and sort the table in Descending order by that measure in that year.
Dataset used was superstore dataset available with Tableau
Below is my attempt to meet the above requirements:
Thanks for reading 🙂
Do subscribe to blog for keep receiving updates