Fixed assets OTBI cross-subject area reporting

I have created a dashboard based on the Subject Area Fixed Assets - Asset Depreciation Real Time. My colleague is asking me to filter the records based on the asset status - whether they're retired or not.

As far as I am aware I could only find this datapoint in the Fixed Assets - Asset Transactions Real Time subject area (eg. the column Retirement Date).

When trying to combine these Subject Areas I get an error. I've tried adding the Asset ID from both subject areas but that did not help.

Could anyone advise on combining these two Subject Areas, and any other considerations I may need to make.