Sorting a table with a parameter

[Marvin]

I am trying to sort a table Asc/Desc based on a parameter so that the user can sort as they wish.

I know the sorting option is available with interactivity, but that doesn't work in my scenario because I need to save the setting outside of the report. The software we're developing can save the parameter as the user chooses, which is why I need a parameter rather than interactivity.

I haven't found a way to do do this, and wondering how to accomplish this.

[Marvin]

I found a work-around from someone who was showing how to do dynamic sorting in another program. 

I created 2 Calculated Field based on the parameter, and added both of them to the sorting option. One is sorted ASC and the other DESC

= Parameters.YearMonthListOrder.Value = "A" ? Fields.FiscalYear : ""

= Parameters.YearMonthListOrder.Value = "D" ? Fields.FiscalYear : ""