Top X filters are applied to the entire data set--it does not account for the dimensions placed on your view. So, in your case, it's first finding the top 5 projects overall, based on total hours and filtering down to only those 5--d, m, h, k, n. You'll need a different approach if you want to get the top 5 to account for the dimensions on your view. I'd recommend using the RANK functions (Table Calculation Functions). RANK_UNIQUE will give you a unique number (it won't give the same number for ties) so that might be good to use here (but, if you have ties on say the fifth item, it will make one of those 5 and one 6, so if you're only showing top 5, that 6th one will be filtered. If you don't want that then use the RANK_DENSE function). I'd create a calculated field called Rank with the following definition:
Then create another calculated field as follows:
Top X Filter
IF [Rank]<=[Top 10 Project Hours] THEN
Add Top X Filters as a filter, then right-click on the pill at edit the table calculation to look like this:
This will account for the dimensions in your view.
See attached workbook. If this solves your problem, please mark this answer as correct. This will help others with similar questions in the future. Thanks!
Top records.twbx 20.5 KB
Thank you, Ken.
Great Appreciate for your help. It's working.
Great. Happy to hear it!!