Hi,
Please find attached a sample excel file. The sheet 1 has the data and sheet 2 contains the pivot table generated by aspose cells java code.
My requirement is to subtract the columns C and D in the pivot table present in sheet 2
Below is the code snippet which i used for pivot table :
pivotTable.addFieldToArea(PivotFieldType.ROW, 1);
pivotTable.addFieldToArea(PivotFieldType.COLUMN, 0);
pivotTable.addFieldToArea(PivotFieldType.DATA, 2);
Please provide a solution for my requirement.
Thanks,
Asha