Finance_Percentage of working hours
Intro: This file sums the budgeted and actual hours for the projects, calculates the percentage of hours used, and shows write-ups and write-downs based on the project price.
In Kompass: Kompass offers an extensive analysis of project performance based on the worked hours with several filtering options. However, it does not offer them in a table format to compare among departments, managers and so on.
File Needed: The workbook can be exported directly from Kompass on the Projects page: open Actions, choose Reports, and select Percentage of working hours.xlsx.
Updating method: If you update your data in Kompass, you will need to export the file again.
The File: There are two tabs on this spreadsheet, [Tables]

and [Graphs].

Slicers can be used to limit the viewed information. They work exactly the same as the column filter buttons, but in a more user-friendly way. The [delivered] slicer is crucial and will filter between delivered and ongoing projects.
Further analysis: There are several ways of slicing and dicing the information. Whichever column can be found in the workbook can also be used for slicing.