Referencing Line Item data (from module) to a general List in another module
Seeking a quick help from all.
I have a list 'Roles' which is being used to define different categories of roles in an organization (refer attachment 1. List - Roles).
In module 'Employee HC L1 (Actual+Forecast)', calculation for headcount is being done for each of these roles. However, the dimension in this module is only time and not role. Different line items have been typed out to associate each role as the calculation logic for each happens to be different (refer attachment 2. Headcount (Actual + Forecast)).
Now in a different module 'Fixed Salary', i want to reference the line items from first module with each list item of 'Roles'. The dimensions being used here are Roles and Time.
I understand one way of doing so can be using Line Item Subsets. Wanted to know a better way.