Hock, I think the attached workbook is what you're looking for. I added a parameter, which links to a calculated field. These toggle between the two sort options you mentioned (I think). Then all you have to do is set the Industry field's sort order to this calculated field:
Hope this helps.
Ooops, here's the attached files.
Message was edited by: DataViz Dude
Earnings-SW.twbx.zip 63.2 KB
This is exactly what I am looking for. Many thanks for your help.
Glad to be of help .