User ability to choose the sorting order in webi report

[Former Member]

Hello Everyone...

I have a case as follows. I am creating a report with multiple columns. One of the columns have max(data) value. after generating the report, user should be able to sort the report based on max(data) column either by ascending or descending.

For example: In sql developer, when we click on top right of the coulmn we can sort the column by asc/dec. kinda.. or similar to that where user should be able to select asc or desc.

Any help on this would be much appreciated.

[amitrathi239 · Accepted solution]

check attached blog.with input control users can do in reading mode.

https://blogs.sap.com/2016/06/13/sorting-data-dynamically-in-a-webi-report/

[Former Member · Accepted solution]

Thanks for your response Amit. The above link sorting is on different columns and doesnt specify ascending or descending.

But I want the sorting on a single column where user can decide whether Ascending or Descending .

Any help would be much appreciated

[Former Member · Accepted solution]

Fantastic! It worked as expected. Thanks!