Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

A solution to last week’s challenge can be found here.

Hi there!

In Weekly Challenge #324, you calculated totals and subtotals using a dataset of food items. For this challenge, calculate totals and subtotals using a dataset from an office supply inventory. Start by categorizing the items under "Computer" or "Standard" to help you calculate the totals and subtotals.

Hint
How to Generate and Format Totals and Subtotals
https://community.alteryx.com/t5/Engine-Works/How-to-Generate-and-Format-Totals-and-Subtotals/ba-p/9...

It would take a few extra tools to get the order to match the output. All the data is there though :)

It would take a few extra tools to get the order to match the output. All the data is there though :)

thanks

seemingly easy task takes quite a few steps..

Challenge #326

Here's my solution.

Added a formatted table just for fun.

@Kenda Did you build your own IfNull function?