Set chart window title to first sorted column

[diffeyj]

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? 

[lironbaram · Accepted solution]

hi 

i don't think this option is available, 

one way you can achieve this create a field with the list of measures in the table 

and give the user option to select one

than sort the table by the dimension and sort the dimension by expression which will change according to the selected measure 

then you'll be able also to select the title by using the selected value