Which Dimension are you trying to filter for a top N? I see the Index() here and the ranking function and this is likely a matter of turning the [LoD for filtering] field into a calculated field so you can specify the more specific elements of the table calculation by using 'Specific Dimensions" but I'm unsure of the specific outcome desired.
I thought no-one was going to respond to this!
I would like to filter on sub-category e.g. show the top 3 sub-categories with the highest total sales for example - due to the multiple data points on each sub-category I can't seem to get it right.
Any help would be appreciated (still!).