We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Challenge #326: Totals and Subtotals Part 2

ctrl_kudorje
7 - Meteor

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

  1. Spoiler
    C326.JPG
CallumWilson
6 - Meteoroid

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

Brian32
8 - Asteroid

Challenge Solution

Watermark
10 - Fireball
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
19 - Altair
19 - Altair

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