I have a straight table attached, It shows top 5 stores by POS Sales desc ranking at default.
Be advised, the attached excel file is just way I want to show in straight table not the data I want to directly use.
Here is what I want, when end user clicks different column header, the table need show top 5 stores by the clicked header accordingly. For instance, if POS Qty is clicked, the table shows stores ranked by POS QTY desc. NOT by POS Sales any more. therefore, it could be totally different store list there.
the confusing part is to show each column data, I have entered expression for each of them, How could I write additional expression and where I put? thanks.
