2 Replies Latest reply on Jul 25, 2012 10:23 AM by Danielle Farrie

    Using sort options in column header

    Danielle Farrie

      I have a view that has bar charts for three fields. I wanted to use a parameter to allow the user to control the sort (asc, desc, or none), but because the fields are created with table calculations this is not possible.

       

      I want to direct the user that they can use the sort buttons in the column header to change the sort to ascending or descending, but I can not figure out how they can clear the sort after making one of these selections. So, for example, the chart shows poverty rates (table calculation) by district. When the view is opened, the districts are sorted alphabetically. Once they use the sort button in the row header to sort on one of the measure fields, is there a way for them to return to the original view sorted alphabetically?

       

      Workbook attached.