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]

Ah yeah @new_user feel free to bring all of your questions here! We try to keep this community approachable so bring your nastiest data questions over and there is a good chance someone around here will know what's up!

@patrick_digan I was having the same problem, originally I thought it was that I didn't have 11.3 (I do now) but that seems to not be the case. I am interested to see how you did it.

Treyson

[patrick_digan]

@new_user Yeah it worked on my end. You'll just want to save the 2 attached files to the same directory. I used the same csv that @Treyson created.

[new_user]

I can open it know and it works :)