The Pivot Manager app provides multiple predefined Business Intelligence Reports. The pivot functionality is also available in some of the other Makersite apps if the 'Grid' view is selected.
The header menu
In the headlines of the table you can find on each column header a small burger menu icon when you mouse over the column.
By click to show the menu, that allows you different actions such as sizing or grouping the columns.
Filter the results
Changing to the filter icon in the middle will provide you with tools to filter your results.
As the filtering is easy to use, Makersite ensures that pivot tables and grids always contain the largest relevant amount of data.
Pivot mode
In the upper right corner of the grid you will find a small horizontal burger menu icon. Clicking it will expand the Pivot Mode.
Here you can choose which columns you are interested in seeing by checking or unchecking the tick boxes. With the Pivot Mode you can start arranging your table by dragging and dropping the columns into the three pivot folders:
Row groups
Values
Column labels
Export your results
Just right click into the grid. In the appearing menu you can easily choose in which format your data is exported.
Integration with BI tools
When creating the pivot results, a link appears in the tool menu below the create button.
This link can be used to connect to standard BI tools such as Power BI or Tableau.