I have a pivot table (Columns are Name and marks) and I have created a dropdown that contains a list (Alphabetical, High to low, and Low to high)
If I choose Alphabetical my pivot should get sorted in Alphabetical order by Name column
If I choose High to low my pivot should get sorted in Descending order by Marks
If I choose Low to high my pivot should get sorted in Ascending order by Marks
If I choose Alphabetical my pivot should get sorted in Alphabetical order by Name column
If I choose High to low my pivot should get sorted in Descending order by Marks
If I choose Low to high my pivot should get sorted in Ascending order by Marks