Total by rows, subtotal by group and column sorting

[mlozovskaya]

I have a data below where I want to archive 3 things:

1. Sort all data by column in alphabetical order 

2. Add total by rows

3. Add subtotal by group and Grand Total

[csmith11]

Hi mlozovskaya,

Does your initial data look like the attached file?

[csmith11]

Hi mlozovskaya,

Please see attached workflow package, that I believe does what you are wanting to do.

Cheers!

[Kamran1991]

Hi @mlozovskaya 

Your question is a little confusing, however initial 2 questions are solved by the joining tool only and rest of the workflow is for last one. I hope this can work.

Thanks!

[csmith11]

I missed the grand total step in my workflow before. I've added this.

[csmith11]

Hi @mlozovskaya

If any of our replies were helpful please consider marking them as the solution, so that others who come across a similar question will be able to easily identify the same solution.

Cheers!