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