Report about monthly License Cost

[Thomas E_]

Hello, we are using SAM Pro and managing SW Models, entitlements and user/device allocations. We have information about cost centers / departments available for each allocated user/device to an entitlement. What I am now looking for is a possibility to report the software license usage cost per department based on the above information - ideally on a monthly basis. Is it possible to create such a report in SAM Pro? 

[dreinhardt]

Hi @Thomas E_, merging the data to use the same filter requires additional effort, e.g., export each report in a custom table and use the database view to create a new "merged" table with a single column "department" for the different objects.

Based on the reporting limitations, customers often export the raw data to e.g., PowerBI and process it there.

Best, Dennis

[Thomas E_]

Hi, I created a calculated field on the alm_entitlement table which always shows the department name of the assigned user if license_metric is per user and shows the department of the user of the allocated device if the metric is per device. In the report, the correct data is displayed as a column of this report, however, if I group by this calculated column, it is not working but shown as "empty". Is this works as designed or is this an issue which should be fixed? 
*EDIT* this can be solved by updating all records of the underlying table which actually adds the calculated values to the database.