Cannot apply sort after using an IN SELECT filter?

Dan Rosen

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?

Dan Rosen

... for reference, even if I remove the groupings (break by) it still doesn't sort