Hide subtotal and classic view in pivot table using VB

Help
,
1

Hi Everyone,

I have created one pivot table using the vb code in invoke code activity.

now i want to do these things in it:

  1. Hide the subtotal
    2.Repeat the labels
    3.classic layout of pivot

can someone please help me in that, i am using this vb code:

oPivotField("UnitCost").Subtotals(1)=True
 oPivotField("UnitCost").Subtotals(1)=False
it is showing me error:
implicit conversion from string to int

please help me for this
2

Hi, I have faced the same error as you. Do you have any recommended solutions on this?