Sort Based on Expression in Pivot

[anushree1]

Hi,

I am trying to sort based on Expression based on Selection of Measure by the User.

I have buttons specifying the sort By options Like Actual, Growth or Growth% and the Pivot Table must sort accordingly as per the measure 

Attached is a sample application , could someone check and tell me how I could get the custom sorting working

[anushree1]

I found the solution using 

=AGGR(DUAL(Year,RowNo(TOTAL)),Div,Year) as my second Dimension.

Please let me know if there is any other better way to get the same