Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
alteryx Community

# 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

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

9 - Comet

Challenge #326

Spoiler

12 - Quasar

Here's my solution.

Spoiler
8 - Asteroid

Added a formatted table just for fun.

Spoiler

8 - Asteroid

@Kenda Did you build your own IfNull function?

8 - Asteroid
Spoiler