1. Feedback
  2. React
  3. 66061

Welcome to the React feedback portal. We’re happy you’re here! If you have feedback on how to improve the React, 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!

3
Votes

Support for displaying repeated headers in the pivot table UI

Currently, when multiple fields are added to the row axis in a Classic layout Pivot Table (in Tabular format), expanding the parent field members displays the parent row header only at the beginning of each hierarchical level, leaving subsequent rows at that level blank. Similarly, when multiple fields are added to the column axis in both Classic and Compact View Pivot Tables, the same behavior occurs. This describes the current functionality of our Pivot Table.

However, in Microsoft Excel's Pivot Table, there is an option called "Repeat Item Labels." This option repeats item and field labels in a Pivot Table, visually grouping rows or columns to make the data easier to read. In the example shown below, the country name is repeated for each row, and the year is repeated for each column.

To enhance usability and improve data clarity, we need to implement the "Repeat Item Labels" feature in our Syncfusion Pivot Table. This feature will ensure that label names are repeated for each hierarchical level within a field, making every row and column header consistently visible, even when expanded. As a result, data readability and ease of interpretation will be significantly improved for users.

Please refer to the following image to see how this feature functions in an Excel Pivot Table.

40249a90-a908-4176-9a61-4f832ebfc6ff.png

Key Requirements:
  •  Provide an option to enable or disable the "Repeat Item Labels" feature.
  •  Ensure that when the feature is enabled, repeated labels are displayed for all expanded rows within a group.
  •  Maintain correct alignment and styling that is consistent with other elements within the Pivot Table.
  •  Optimize the feature to handle large datasets without significantly impacting performance.
  • Include support for 'Repeat Item Labels' in Excel, CSV, and PDF export functionality when using the classic layout.