Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
alteryx Community

# 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.

## Challenge #326: Totals and Subtotals Part 2

Alteryx

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...

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

16 - Nebula
Spoiler

7 - Meteor

thanks

7 - Meteor

seemingly easy task takes quite a few steps..

Spoiler

11 - Bolide

Challenge #326

Spoiler

12 - Quasar

Here's my solution.

Spoiler
9 - Comet

Added a formatted table just for fun.

Spoiler

9 - Comet

@Kenda Did you build your own IfNull function?

9 - Comet
Spoiler