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