Disable Excel Pivot Subtotals In Peoplecode

Hello,

I am attempting to create a data export / transformation in a PeopleSoft app engine. I am able to do basically anything outlined in the documentation for the Excel COM Interop.

I am attempting to create a pivot table with no subtotals. I am able to create the table with no issues but due to the syntax expected, the People Code will not compile properly.

I currently have:

&oPivotField.Subtotals(1) = False;

This is the correct way to disable this subtotal according to Microsoft but it does not compile. I have tried ObjectSetProperty(&oPivotField, "Subtotals(1)", False), &oPivotField.set_Subtotals(1,False); &oPivotField.Subtotals(1,False) with no luck.