Search

Close

Start Free Trial

Weekly Challenges

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

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

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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?