Launch, grow, and unlock your career in data

June 21, 2017

Workout Wednesday: The Value of Top 3 & Top 5 Contributors

This week's Workout Wednesday came about from a problem I was trying to solve with our French team, so thanks to them for the challenge! Here's the scenario:
First, we wanted to understand what percentage of sales come from the top 3 and top 5 subcategories in each quarter, then we want to understand the cumulative contribution through time.

So that's your challenge. Build the viz below using this data source with these conditions:

  1. Match the title
  2. Match the tooltip
  3. Match the colors
  4. Show the contribution of the top 3 and the top 5 subcategories in each quarter
  5. Bar height represents the cumulative contributions from the first quarter
  6. Use only one worksheet
  7. Viz size is 800x600

I'm pretty sure that's everything. If I missed something, leave a comment or tweet me and I'll update the requirements. Remember to post you version to twitter and tag @EmmaWhyte and @VizWizBI. Good luck!


  1. You say top 3 and 5 subcategories in the Title, but Products in the Tooltip. re we summing Sales for Subcategories or Products?