We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to hidden the subtotal in the pivot table?

Here are settings I tried, but the subtotal is still there.

pivotField.setSubtotals(PivotFieldSubtotalType.SUM,false);
pivotField.setAutoSubtotals(false);

pivotField.setSubtotals(0, false);
pivotField.setSubtotals(1, false);
pivotField.setSubtotals(2, false);

Coordx Coordy Pocketid Reelid
2 8 (blank) (blank)
(blank) Total
8 Total

I want to remove the subtotal in Bold, anyone can help? Thanks.


This message was posted using Page2Forum from Smart Features - Aspose.Cells for Java

Hi,


Please give us your complete sample code and also attach the template file(s), so that we can check your issue soon. Moreover which version of the product you are using? We recommend you to use our latest version/fix v7.0.1.x.

Thank you.