I have a simple problem I am stuck with. I want to provide option for my client to sort a table in ascending or descending order. I have 4 dimensions in the table, now when i click on the automatic sort button that appears when I hover over my measure field, nothing happens. even when I tried sorting by field, sorting on dimensions, it works for only the first dimension in the row column. if I sort on other dimensions nothing happens.
Please suggest any options where in I can provide my client an option to sort in this scenario.