I have a cube with several dimensions. I need (a measure, calculation, whatever...) to show last value of a column, assuming the table is sorted by another column.
Something like:
SELECT TOP 1 column_1 FROM table_1 WHERE «The user's selected dimentions will work as a filter» ORDER BY column_2 DESC