I have a numbered list where I imported data from staffcosts. My model contains this hierarchy: Staff, parent is Costcenter, parent is Financial controller. Because people are moving from one costcenter to another the staff's parent is updated monthly. But when I go to the forecast module I only want to see the salarycosts that belongs to the current parent.
Is there a way to make a certain matrixmodule wich applies to Staff (list) and Time and then presents the costcenter of this combination as imported in the numbered list I mentioned before?