Forum Discussion

brad_k's avatar
brad_k
New Member
5 years ago

Column Sorting of Matrix on Web

I have created a Matrix that is using columns to divide the data between multiple branches.

I need the ability to dynamically sort the data based on details from within one of the columns i.e. sort the whole table by branch 1's sales while still showing the data from other branches. The default sort only sorts on total rather than the divided data.

Is this possible? If so how do I set it up?

Thanks for your help.

2 Replies

  • brad_k , As far as I know, if you are using column (pivot), then you can sort only on column total.

     

  • amitchandak How do you do a Pivot sort through the web interface on live data? Can I create a button to do this?