In the User Experience, page builders use the view designer to shape and tailor views of their data for worksheets, boards and reports.
View designer has real-time pivoting capabilities for customisations. This enables you to pivot row and column dimensions without losing existing customisations or compromising the visibility of your data.
With real-time pivoting, there is no need to re-apply customisations each time you pivot. This means you can amend your logic on-the-fly for a faster, more responsive build experience in the User Experience.
The ability to pivot grid data and its customisations depends on whether or not the data is nested.
For non-nested grids, real-time pivot supports the following customizations:
- Show/hide, via the context menu and right-hand configuration panel
- Reorder, via the context menu and right-hand configuration panel
- Sort
- Filter
- Level selection
- Totals position
- Conditional formatting
For nested grids, real-time pivot supports the following customizations when in a nested grid:
- Show/hide, via the context menu and right-hand panel
- Reorder, via the context menu and right-hand panel
- Level selection
- Conditional formatting