Multiple subtotals from multiple sorts of Table

[KONTEK]

HI,
I am trying to get different SUBTOTALS from a table depending on the sort.
For example, I want to know how many accounts each of my account managers have. I have a master table with all of our accounts, and if I sort that table by account manager, I can get the total. But I want to take that total by account manager, and plug it into another table.
Any help would be greatly appreciated.
Thank you

 

[SpillerBD]

Pivot Tables can give you the Subtotals, and it is relatively easy to change the grouping order; effectively your sort order.