asset category column for OTBI report

Summary:

I am trying to create an OTBI report with Asset Category as one of the columns. I am facing issues with assets that have been transferred multiple times from one category to another. For these assets, Category column is showing all the categories the asset had been assigned to (multiple rows for Category).

I want to report on the latest Category the asset is assigned to. I have tried all the Assets subject areas and Category columns within these subject areas but unable to find a column that can give single row for asset category.

The seeded Asset Register report also shows only the latest asset category.