Total by each group of rows

[new_user]

Is it possible to group data by multiple columns, and then adding 'two-level' Total rows on each group? 

Example for it is attached.

There is count on each row (easy to add), and at the end of each group should be two rows- Total by Field1 and Total by Field2

[Treyson]

Hello @new_user! That's going to be an awesome name when you are an Alteryx pro because then you can still get away with asking any questions and no one will bat an eye.

Using the Summary tool you can absolutely group by multiple columns (demo on the way). Are you asking specifically if we can create an output like the one attached (with subtotals and the like)?

Treyson

[new_user]

I am aking is it possible to add subtotals as in example attached

[Treyson]

Reading back over the question, I now see that that was exactly what you asked for. I was just so excited about your user name that I went off the rails. I am sure we can, let me play around with a few things and get back to you.

Treyson

[new_user]

Aha, ok.. I am happy to hear that is possible :)

[Treyson · Accepted solution]

Oh boy.

So this one took a bit of trial and error because of sorting. I tried to make it as dynamic as possible so no matter how many groupings you have it would fit into your data. Let me know if you have any questions.

I bet that if we ask @MarqueeCrew (Mark) he would tell us to use the tile tool. Mark can we use the tile tool on this one?

Treyson

[MarqueeCrew]

@Treyson,

#GoodLuckWithThat #NoTile

[patrick_digan · Accepted solution]

@new_user I took a similar approach to @Treyson but tried to use less tools. I used a recordID to help with the sorting. Hopefully our 2 answers will point you in the right direction!

[new_user]

Thank you, Treyson! Because I am new_user this was so educative for me :)

[new_user]

Patric, can you check if the attachment is ok? For some reason I can't open workflow.. Thank you