Sort the data in Pivot Table filters RRS feed

  • Question

  • Can anyone help with sorting the data in a pivot table report filter, so it is sorted A-Z or Highest to Lowest depending on the data format witing the drop down list in MS Excel 2007?

    I am creating pivot tables buy importing data directly from an MS Access 2003 database query.  The data in the report filters is mixed up and doesn't seem to be sorted which makes them much more difficult to use.  Al other areas of the pivot data can be mananaged to display correctly.  However Report Filters are proving more difficult to understand.

    Thanks for any help you can provide.


    Tuesday, November 9, 2010 2:43 PM