Pivot table - How to hide subtotals?

ZedZed Member Posts: 2
Hi!
I'm making a excel pivot table out from Nav (5)
Everything works fine, but i need subtotals to be hidden.
Can anyone post the exact C/AL code for it?
In VB it is:
ActiveSheet.PivotTables("PivotTable1").PivotFields("My Field").Subtotals = _
        Array(False, False, False, False, False, False, False, False, False, False, False, False)

IN C/AL :
xlPivotField := xlPivotTable.PivotFields('My Field');
xlPivotField.Orientation := 1; 
xlPivotField.Position     := 1;
xlPivotField.Subtotals   := ???;
Sub.jpg 51.9K

Comments

  • SteveKnottSteveKnott Member Posts: 49
    Wondering if you ever found a solution to this... facing the same issue.
Sign In or Register to comment.