I don’t think that’s what I need,
Mine is a simple crosstab hierarchy where user can drill down or up and it should sort based on the metric selected both at the higher and lower grain upto the point the hierarchy is drilled.
Not sure I' understand the request correctly or not, anyways here is my approach..
Create calculated fields.
[Display Dimensions 1]
if [Select dimensioins]="Brand" then "" else [Brand] end
[Display Dimensions 2]
if [Select dimensioins]="Dept." then [Department] else [Brand] end
if [Select dimensioins]="Brand" then [Brand]
else [Brand]+" "+[Department]
if [Select Mesure]="Sales" then [Sales] else [Profit] end
dynamic sort key_SM_9.3.twbx 17.2 KB