Advanced Filter Macro with subtotal?

[Add564656]

Hi,
I am using the below vba code to advance filter but I would like to use subtotal at the bottom of it, when I check the total box on the table design options it messes up my macro.

Sub FilterDataMANIFEST()

Range("Table2[#All]").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
Sheets("Output").Range("A1:A2"), CopyToRange:=Sheets("Pallet Manifest").Range("A14:J14"), Unique:=False


End Sub

Could someone help or tell me if it is possible?

Thank you