Do Aspose cell support aggregation method – ‘distinct count’ for pivot table data fields? It is present in Excel 2013.
I have downloaded aspose-cells-8.4.0-java jar file from your website (http://www.aspose.com/community/getting-started/java-components/aspose.cells-for-java.aspx ). There is no error but I cannot able to change aggregation method for columns (by default aggregation method used on column is sum). I want to change to some other method, say – count, average. I am not talking about subtotals for row, but for whole column (grand Summary for column).