3 Replies Latest reply on Feb 9, 2012 7:40 AM by Ruben Longoria

    sort is not recalculating after filtering data

    Ruben  Longoria

      I've got a workbook with columns for each city, and I'd like to sort the rows by the highest value to lowest. Changing the Parmater from monthly to weekly, filters the data and the row total for each city is modified, but now the second column is higer than the first one. I need to select the value and click the quick sort button each time I change the paramater or filter. Its possible to sort automatically after filtering?

       

      Attached is a workbook sorted via quicksort to show what I am after, all I need is the sort to update as you modify the month/week parameter.