sorting QlikSense Pivot table

[ilanbaruch]

hi All,

any ideas on how to give users the option to sort a pivot table??

Advanced thanks

[ilanbaruch]

load * inline[ SortBy

Value1

Value2

Value3

Value4];

if (getfieldselection (SortBy)='Value1',sum(Amount),

if (getfieldselection (SortBy)='Value2',count(user_id),.....