Enhance the Syncfusion Pivot Table component to allow users to drag and drop the same field multiple times into the Values section of the Field List dialog. This functionality will enable users to apply different aggregation types (e.g., Sum, Average, Count, etc.) to the same data field, facilitating more advanced and comparative data analysis.
This feature is widely used in data analysis tools and is essential for comparing various summaries of the same metric side by side. Implementing it will significantly improve the flexibility and analytical capabilities of the Pivot Table.
Enhancement Goals:
- Allow the same field to be added multiple times to the Values axis from the Field List tree view UI.
- Enable users to apply distinct aggregation types to each instance of the same field.
- Ensure compatibility with existing Pivot Table features, including:
- Sorting and filtering
- Field list updates
- Exporting (e.g., Excel, PDF)
- Chart integration
Design Notes:
- This enhancement applies exclusively to the Values axis.
- Adding the same field multiple times to the Row, Column, or Filter axes will remain restricted to preserve standard Pivot Table behavior and prevent ambiguity in layout generation.