I have a fairly "standard" straight table. It has a single dimension and a number of expressions around Sales.
I want the Window Title to update as the user changes the sort order. So if the user sorts on cost then I want it to say 'YTD Sales Analysis by Cost', and when they select Margin, it should say 'YTD Sales Analysis by Margin'.
Is there any function that can get the label for the first column (dimension or expression) in the Sort Priority?