Pivot functionality

Grid, Pivot manager

F
Written by Fabian Hassel
Updated over a week ago

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. 

Did this answer your question?