Pivot-tables
Pivot-tables behave similar to queries but only contain a single table or chart (in difference to queries, which work more like dashboards and can contain more elements).
Pivot-tables can be edited inside the browser and use a new and flexible viewer, which e.g. allows to scroll inside the table without moving the table headers out of the view or to change the visualization of the table while viewing it.
Because pivot-tables and queries have many similarities, you can easily change between both formats. You can create pivot-tables from a block inside a query or you can publish pivot tables as queries also. The basic difference between both is only the maximum number of elements they may contain.
Contents of this chapter:
Opening existing pivot tables
Creating a new pivot table
The analyzer
Working with pivot tables
Editing pivot tables
Charts
The expression editor
