1. Feedback
  2. JavaScript
  3. 5859

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

21
Votes

Classic (Tabular) layout support for EJ2 PivotTable

Currently, our Syncfusion EJ2 Pivot Table only supports displaying data in a Excel-like layout, which is essentially Excel's "Compact" form that allows displaying the summary cells positioned besides each parent member and their child members appear next to them in the pivot table UI.


However, MS Excel an Power BI have "Classic layout" (also known as the "Tabular" form as an additional option, that allow displaying summary cells are positioned at the bottom of each parent member and their child members appear next to them. in the pivot table UI. So similar to the Excel, we need to provide this tabular mode option in our Syncfusion Pivot Table. Please see the example screenshot for reference.


Furthermore, when implementing this tabular layout form, we have to consider features relevant to the pivot table UI, such as virtual scrolling, selection, summary customization, templates, and exporting, all of which are currently supported by our pivot table's compact layout.