Hello Aspose Support Team,
could you please advise me about the distinct count in pivots? We are using Aspose.Cells for Java to generate Excel reports. Our workflow is as follows:
- We start from an Excel template.
- Our Java application creates a copy of a worksheet.
- A database result set is written into the worksheet as a flat table.
- Aspose.Cells creates a PivotTable based on this data.
- End users can then modify the PivotTable layout in Excel by moving fields.
One of our requirements is to support Distinct Count as a value aggregation. It is important that the value is recalculated automatically whenever the user changes the PivotTable layout. From our understanding, this is currently not possible because Distinct Count is only available for PivotTables based on the Excel Data Model (Power Pivot), and Aspose.Cells cannot create or populate such a Data Model programmatically.
Could you please confirm whether this is still the current state of Aspose.Cells for Java?
If not, could you please point us to the recommended approach?
Thank you for your help.