Hi,

Am Thu, 6 May 2021 11:58:48 -0500 schrieb dpb:

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.

1. PivotTable Options = Display and activate "Show expand/collapse
buttons
2. Right click to the groups and choose "Subtotals "Group""

Have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgfBF...YM9WQ?e=msZb71


Regards
Claus B.
--
Windows10
Microsoft 365 for business