I don't yet understand much about pivot tables -- I can create one that
has such a sample data set as

B62503
Allied Health - Nursing $2,900.00
Allied Health - RT $1,500.00
Allied Health - ST $1,000.00
Allied Health-Sports Medicine $9,661.48

which is great in that it has everything for the accounting fund code
B62503, but ...

I have to manually collapse the group to get the subtotal and when do
that, the identifying main text goes away so it's "flying blind".

Is there not a way to get a subtotal in the group as well? -- Seems
pretty obvious thing one would want.

I then would like/need a way to autogenerate such pivot tables in a new
workbook instead of also having to create them manually.

Thanks for any guidance...

--