Pivot tables

Owned by Henryk Rybinski
Last updated: Oct 28, 2024
2 min read

Pivot tables can be run for a result of a query. If for example we search for all projects starting in 2018-2024 we can use the query answer as an input for the project pivot:

image-20240316-192409.png

Having defined rows, colums and aggregate we can get a table of all projects over the years with the specified University role:

 

image-20240316-193518.png

 

or in the graphical form:

 

By adding the column Budget we get another table

To analyze the structure of projects by funders, you just change the definition of rows, removing WUT role and drug- and-drop the attribute Contracting Authotity from the list of available attributes, instead:

 

 

 

 

 

 

The generated tables can be exported to excel or more advanced BI tools for further processing