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: