Total by rows, subtotal by group and column sorting

Question

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

Example with Totals by rows and sort by column header.xlsx

csmith11 · Answer

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!

csmith11 · Answer

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

Total by rows, subtotal by group & grand total and column sorting.yxzp

Kamran1991 · Answer

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!

Total by rows, subtotal by group and column sorting.yxmd