Challenge #326: Totals and Subtotals Part 2

[ctrl_kudorje]

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

1. Spoiler

   

[CallumWilson]

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

[Brian32]

Challenge Solution

[Watermark]

Spoiler

 

[mgutshall1114]

Spoiler

SPOILER

[toriastahl]

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

[J-Riedel]

Spoiler

Spoiler

[ARussell34]

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]

Nice one.

Spoiler

[pooja2010mukul]

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