Thank you @AntrikshSharma,
So going to a Many to One filter between Airline Master Sheet and Credit Risk scores does allow the date filter to Accipiter become active.
However it then throws off my filtering in the my model.
Let me try better articulate the issue/what I am trying to acheive:
- Master Sheet
This is a static sheet that includes one data base code per row and across the column is several descriptors. But there is no time series on this. One of the key filters I have is where the airlines is “owned”, “Managed” or “No Exposure”.
However over time the exposure I have to a single database code will have changed due to the shift in the customer base.
Therefore I need the be able to filter back into this sheet by owned, managed and no exposure from the credit risk score
- Credit Risk Score
This is output from our risk models that provide a credit risk score per airline and is a tie series. It goes back to 2018 and has a score per airline in each period.
In addition it also has other filter columns with the owned, managed and no exposure being the most vital as this then allows for time serious analysis of the risk score.
- Accipiter NBV
This the NBV by aircraft for each month end.
The data includes the database code to identify the airline
What I am trying to achieve is a model where I can filter by date and by owned, managed or No Exposure and the model will then give me:
a) the credit risk score of
b) the airlines that are in the Owned and
c) the sum of NBV of that airline at
d) the filtered date
Any ideas how I might achieve this. Intuitively this seems like a fairly basic sort of approach when try to cross filter large data sets across a business.
Thanks so much