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

Free Support Forum - aspose.com

Set function on pivot data fields

hi
in pivot table generation the default function for data fields is sum.
is there any way set other functions to it.

like count, average,max and min for data fields.


thanks and regards

Ranjith.

Hi,


You may use PivotField.setFunction() method for your need and you have to do it in your code:
http://www.aspose.com/documentation/java-components/aspose.cells-for-java/com/aspose/cells/pivotfield.html

Thank you.