Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Total by each group of rows

Highlighted
7 - Meteor

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

 

Highlighted
12 - Quasar
12 - Quasar

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

Highlighted
7 - Meteor
I am aking is it possible to add subtotals as in example attached
Highlighted
12 - Quasar
12 - Quasar

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

Highlighted
7 - Meteor
Aha, ok.. I am happy to hear that is possible :)
Highlighted
12 - Quasar
12 - Quasar

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

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@Treyson,

 

#GoodLuckWithThat #NoTile

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
15 - Aurora
15 - Aurora

@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!

Highlighted
7 - Meteor

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

Highlighted
7 - Meteor

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

Labels