I have a situation where I am adding an IN SELECT FILTER to a table visualization, for example:
[Dim.A] IN ( SELECT TOP 1 [Dim.A] FROM [All] WHERE [Dim.B] = GETPROMPTVALUE('Dim.B') ORDER BY [Dim.Time] DESC) )
This filter works fine, but the issue is it prevents my table from sorting. The table is just a standard table with a couple of groupings, but when I try to sort on an order column within the grouping it doesn't allow me to. The sorting works fine if this filter is not applied.
Any ideas?