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

Free Support Forum - aspose.com

Setting subtotals to None

Hi Team,

Please check the attached image and let me know how can i achieve this in java.

Excel.jpg (555.5 KB)

@sukesh.kotian,

Thanks for the screenshot.

See the following line of code for your reference:
e.g
Sample code:


pivotTable.getColumnFields().get(0).setSubtotals(PivotFieldSubtotalType.NONE,true);

Moreover, see the documents/articles in the section on how to create and manipulate PivotTables for your complete reference:
https://docs.aspose.com/display/cellsjava/Pivot+Tables