We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

Challenge #326: Totals and Subtotals Part 2

ctrl_kudorje
8 - Asteroid

Usage of Running count, sampling, Rename to get output.

  1. Spoiler
    C326.JPG
CallumWilson
7 - Meteor

Fun challenge, definitely not the most efficient flow but it works :)

Brian32
8 - Asteroid

Challenge Solution

Watermark
12 - Quasar
12 - Quasar
Spoiler
326_MT_Solution.jpg

mgutshall1114
5 - Atom
Spoiler
SPOILERmgutshall1114_0-1657723993032.png

 

toriastahl
6 - Meteoroid

good use of summarize for totals and subtotals, fun to play around with formatting of sheet at end

J-Riedel
8 - Asteroid
Spoiler
SpoilerJRiedel_4-1657742005132.png

 

 

 

ARussell34
8 - Asteroid

I find it fascinating that the standard items were more expensive for each company over the cost of computer supplies. I'm not sure what company B's need for 105 worth of staplers, but that's what set their total cost overall to be the greatest among the four companies.

Qiu
20 - Arcturus
20 - Arcturus

Nice one.

Spoiler
Challenge_326.PNG
pooja2010mukul
5 - Atom

Solution: I have firstly filtered computer and standard product and then union summarized value and pre existing values to have the totals.

pooja2010mukul_0-1657792454643.png