It would be useful if you can give an example of the correct numbers in one or two scenarios since the result you are after is hard to grasp when there's nothing to compare results to. In general you can use context filters to filter data from a FIXED expression, so making every filter but Time Period and Utilization Type a context will ensure that the context filters changes affect the FIXED but the normal ones do not. Be careful when summing countd values for you can double count people in different sections. For 3) I am not certain what you are after, should the hours change based on the Time Scale toggle ? I've given it a try based on a few minutes of looking at your data but I can't be sure it's what you are after.
Let me know if I am anywhere close.
Utilization Forecast VP.twbx 71.2 KB
Thanks Vasil for the try, but this does not seem to be fixing the problem I'm having. The Utilization type filter still affects my # of Employees even if I add the rest of them as context filters.
Apologies for not sharing a concrete example of my expected output,
Above is my list when Utilization type is not filtered, the numbers here are all as they should be. i.e. The # of employees for Level 1 across all the months is 94
The second list shows the number of employees when we remove one particular utilization type. The value of #of employees for Level 1 SHOULD be the same as the first image i.e. 94 across all months but it has reduced and is even different for each month
The Total Estimated Hours and The Weekly Standard hours - the second numeric column - are being brought properly and don't really need any change. But the # of employees needs to be fixed irrespective of changing Utilization types.
Does my explanation cover the basis of the problem?
Another issue that comes up is that I need the value to change based on changes to the Level, Location, Space name ,Space Lead and Capability Group filters but stay constant ONLY with respect to the utilization type filter. With this solution I will have a fixed value when I change the filters which would be a problem. Any workaround to that?