From the course: Tableau: Mastering Calculations

Unlock the full course today

Join today to access over 24,200 courses taught by industry experts.

Challenge: Table calculations

Challenge: Table calculations - Tableau Tutorial

From the course: Tableau: Mastering Calculations

Start my 1-month free trial Buy for my team

Challenge: Table calculations

“

Ready for another challenge? Our colleagues from the marketing team have called with a request. They love the report that shows them how many units have been sold per category and SKU, but they need to know the quantity for each category overall as well. We offer to create a second report without the SKUs, but they want everything in one view, and they don't want us to simply insert the subtotals, because that distorts the axis too much. And they don't want us to change the view to a simple table because they love the bar charts so much. Instead, they asked if we can simply put the sum of the quantity for the whole category in the labels, for example. So that is your challenge. Calculate the window sum for the sum of quantity. Don't forget to set the correct computation. You get a bonus point if you also add in the percentage of quantity sold in a SKU within its category. This challenge should take you about ten minutes. Best of luck!

Contents