1. Feedback
  2. Angular
  3. 67870

Welcome to the Angular feedback portal. We’re happy you’re here! If you have feedback on how to improve the Angular, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

Support for Adding the Same Field Multiple Times to the Values Area in Pivot Table

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 capability will allow users to apply different aggregation types (e.g., Sum, Average, Count, etc.) to the same data field, enabling more advanced and comparative data analysis.

This functionality is commonly used in data analysis tools and is essential for comparing various summaries of the same metric side by side. Implementing this feature will improve the flexibility and analytical capabilities of the Pivot Table.

Enhancement Goals:

  • Enable the same field to be added multiple times to the Values axis from the Field List tree view UI.

  • Allow users to apply distinct aggregations to each instance of the same field.

  • Maintain compatibility with existing Pivot Table features such as:

    • Sorting and filtering

    • Field list updates

    • Exporting (e.g., Excel, PDF)

    • Chart integration

Design Note:

  • This enhancement is applicable only to the Values axis.

  • Adding the same field multiple times to the Row, Column, or Filter axes will remain restricted, in accordance with standard Pivot Table behavior and to prevent ambiguity in layout generation.

Reference:

Please refer to the attached screenshot for a visual representation of the expected behavior.

Image