1. Feedback
  2. Angular
  3. 21519

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

Allow multiple fields on same grouping level in row / column axes

We have a request from users who would like to be able to use the pivot grid and view multiple fields in a row or column, but they do not want the columns to appear nested under one another since they will always be unique. As an example the user may want to see a person's ID, gender, and date of birth in a row. Right now they can drag all 3 field onto the axis, but it repeats the data since it considers each field to be under the other one. 

We would like some way to have this data be discrete data elements and yet be combined on an axis. Some possibilities would be:

1) Allow for the creation of concatenated fields similar to "calculated fields" but for string manipulation and not math/aggregation, and allow those fields to be places of the column/row axes (OK with these not being filterable).
2) Allow the user to specify that fields on the column/row axes are "at the same level" and not "beneath" the field above it. Then all data can display in the column/row and the aggregated data displays once. If the user tries to make fields appear at the same level where there are data points that don't match (i.e. some data points for the same ID have a different gender) then the control could disallow this functionality.

3) Less desirable, but allow the user to toggle the display of the value of the parent row(s) in the child rows. This would still have duplicated rows but would allow for the full value the users desire to be on the child rows, which they could then export and clean up the duplicates on the report. This would be similar to Excel Pivot table "Repeat item label" functionality.

Any other suggestions/solutions would be welcome as well.



Thanks,

Michael