Problem with Top 10 Filter Pivot Table MAC

Hey Y'all!

Been searching for hours and simply CANNOT for the life of me find an answer to this problem I'm having.

I have a very simple excel sheet with ~6000 rows in 2 columns (Point A, and Point B)

When I create a pivot table, it comes out fine.. But when I filter by value for the Top 10, it seems to show the lowest cells, not the most occurring.

Not only this, if I sort by Bottom 10, it seems to give me the top 10 numbers, although if I expand to see the bottom 20 (let's say), it gets rid of one of the original numbers that were in the top 10.

Does anyone have any idea what the problem is here? My friend who filtered it on his windows got it to work perfectly fine; however, mine is BACKWARDS?

Any suggestions or help would be greatly appreciated as I have NO IDEA, 3 hours of research later on what the problem is or how to fix it.

Thank you very much hope to hear from y'all soon!

PS: something along the lines of this problem here: http://answers.microsoft.com/en-us/m...b-bf0fecf24056

Originally Posted by adhawan06

Hi Seire,

Could you please upload the attachment here.

Go to "Go Advanced"--> Click on Paper Clip sign (See below image)

Attachment 387496

Testing.xlsx

Attached. As you can see, the small set of data that I typed up (sheet 1&2) seemed to work, but the pivot table I created on Sheet 3 from Data on Sheet 4... Is broken?

I'm not sure of what the problem is, but like I said it seemed to sort out fine on my friends Windows system, but my Mac excel is being buggy..

PS: Once I get the pivot table correctly, is there a way to extract the top numbers in list format? Something in maybe 3 columns such as: Point A | Point B | Count ?

Thank you so much!!