You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers App used on Ipad

Data will not sort correctly after creating pivot table. Dates are formatted correctly but are sorted as numbers.


iPad, 15

Posted on Mar 31, 2022 4:11 PM

Reply
Question marked as Top-ranking reply

Posted on Apr 1, 2022 11:31 AM

try this…

make sure to have a cell in your pivot tab selected

then click the button to modify your pivot table (circle with three lines in it)

down in the rows section, tap the Little “i” next to your date field

on that screen that pops up make sure name is selected.

the system is smart enough to know that name with dates isn’t alphabetical it’s by date.


2 replies
Question marked as Top-ranking reply

Apr 1, 2022 11:31 AM in response to jaxjason

try this…

make sure to have a cell in your pivot tab selected

then click the button to modify your pivot table (circle with three lines in it)

down in the rows section, tap the Little “i” next to your date field

on that screen that pops up make sure name is selected.

the system is smart enough to know that name with dates isn’t alphabetical it’s by date.


Numbers App used on Ipad

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.