Excel mac 2011 pivot table filter

I've noticed that if I amend the data source then on the pivot table the modified number "climbs" to the top of the list and still can't filter into ascending order? In pivot table options - Layout tab down the bottom there are "Sort" options which I have also played around with and still doesn't change what I am trying to do. Did this solve your problem?

Yes No. Sorry this didn't help. You can see that the Cost Centers beginning with "0" will not filter to top of the list??? Above is the Settings for this pivot table, thinking that the "Sort" option here would override Field filter settings but it doesn't do anything or change the filter order I then went back to my pivot table to check the filter again to SORT in ascending but again with no luck. Thank you for posting a link to the workbook.

It makes it SO much easier to figure out what's happening. Have a look at the Job Card worksheet. The cells having an error have "Number stored as text. There is a mix of cells having numbers and cells having text.


  • best video card for 2007 mac pro.
  • mac os vpn configuration file.
  • Sort data in a PivotTable - Excel for Mac?

If you want your sort to work then all values in column A must be either numbers or text. When you have a mixture of data, you get a mixed sort result. I am an unpaid volunteer and do not work for Microsoft. I've selected the A column and changed format to "Text". I have click the on filter on column A to "Ascending" with NO response??? Use another column as a "helper" column on the Job Card worksheet. For example, use column J, which presumably has General format the default.

Format column K as text.

Pivot Table Filter Not Working

This pastes the entire list of numbers as into the column, which is formatted as text so it keeps the leading zeros. Your column A1 should now show the Cost center code and everything should have shifted over 1 column to the right Delete column B formerly column A Re-create your pivottable Your pivottable will now have the order you expect. Skip to main content. Site Feedback. Tell us about your experience with our site.

DeanDe Petra Created on May 3, You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Pivot Table Filter Not Working - Microsoft Community

Filtering a PivotTable field by selection. You are now leaving Lynda. To access Lynda.

Visit our help center. Data Analysis. Preview This Course. Course Overview Transcript View Offline Exercise Files - [Voiceover] Pivot tables can summarize…huge data collections,…but many times you'll want to limit the data displayed…within a given category. Resume Transcript Auto-Scroll. Author Curt Frye. Learn how to use PivotTables to summarize, sort, count, and chart your organization's data in Excel for Mac Author Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. He shows how to build PivotTables from single or multiple data sources including external spreadsheets and text files , add calculated fields, filter your results, and format your layout to make it more readable.

Topics include: Skill Level Intermediate. Show More Show Less. Related Courses. Preview course.

Excel for the Mac: Managing and Analyzing Data with Dennis Taylor. Advanced Formulas and Functions with Dennis Taylor. Excel for Mac Charts in Depth with Dennis Taylor. Search This Course Clear Search. Welcome 1m 6s. What you should know before watching this course 1m 41s. Using the exercise files 34s. Creating and Pivoting PivotTables.

Introducing PivotTables 4m 15s.

Was this information helpful?

Formatting data for use in a PivotTable 2m 56s. Creating a PivotTable 2m 51s. Pivoting a PivotTable 2m 58s. Configuring a PivotTable 4m 12s.

Filtering a PivotTable field by selection

Creating a PivotTable from a text file 3m 55s. Refreshing PivotTable data connections 5m 35s. Managing PivotTables 4m 16s. Summarizing PivotTable Data. Managing subtotals and grand totals 4m 6s.

Question Info

Changing the data field summary operation 4m 40s. Summarizing more than one data field 3m 12s.