I’m merging two sets of data: Forecast (live_data) and Actual (SAP Actuals).
When building a matrix, I’m using a field which is common across the two, which is the ProjectKey (noticed this field is called “Applicant” in SAP Actuals).
Problem is that if I use only Forecast code (coming from live_data) I get the right ProjectKey by Company:
However, if I drag Spend (coming from SAP Actuals) I have ProjectKey from other Companys that doesn’t belong to India for this case. Actually, I get all ProjectKey available for all CapEx Company which is wrong, meaning I should only get the right ProjectKey by Company (see C-US-…(this is for United Stated and is popping up under India)
I’ve re-visited my model several times and not sure what might be causing this issue…
Any hint here would be highly appreciated
CAPITAL EXPENSES.pbix (716.5 KB)