Hi,

Am Thu, 6 May 2021 13:29:25 -0500 schrieb dpb:

Thanks, Claus. It doesn't seem to work with Excel 2016...whenever try
to Right click and subtotal, get error of

"A PivotTable report cannot overlay another PivotTable report"

in this case you have another PivotTable under the first one. Insert
rows between the PivotTables that the first one doesn't overlap the
second one if there is one more line per group is inserted.


Regards
Claus B.
--
Windows10
Microsoft 365 for business