I pull a pivot table from an Access database (see Table 1 snippet). My
objective is to summarize the detail when the grand total is zero
(‘Grand Total’ is row total of pivot table). I have been using a
manual process of selecting and grouping the rows that equal to zero
then hide details (See Table 2). I make about 10 duplication of the
worksheet for different departments however, whenever I select and
group on one pivot table it affect the pivot table on every other
worksheet. Can the grouping and summarizing be accomplished with vba
if not is there some link to break so that the manual grouping and
summarizing in one table does not replicate in the other? Thanks for
any and all help.

TABLE 1

FEC TG

Sum of TotAmount Source
Month batch GL MIDI Grand Total
Jul-07 1875UTB8 50,000.00 50,000.00
1876UTB8 1,000.00 1,000.00
1880UTB8 7,000.00 7,000.00
1887UTB8 10,000.00 10,000.00
7647UDH7 (50.00) 50.00 -
7678UMX7 (100.00) 100.00 -
7786UIN7 (1,000.00) 1,000.00 -
XF72570128 (1,350.00) 1,350.00 -
XM71770022 (4,740.00) 4,740.00 -
XP71970053 (300.00) 300.00 -


TABLE 2

FEC TG

Sum of TotAmount Source
Month batch2 batch GL MIDI Grand Total
Jul-07 1887UTB8 1887UWB8 10,000.00 10,000.00
1876UTB8 1876UWB8 1,000.00 1,000.00
1875UTB8 1875UWB8 50,000.00 50,000.00
1880UTB8 1880UWB8 7,000.00 7,000.00
Group1 (472,867.17) 472,867.17 -