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.

📢 Newsroom Update

Apple introduces powerful new iPad mini built for Apple Intelligence. Learn more >

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

Level 1

4 points

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

Top-ranking reply

Level 5

5,047 points

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.

View in context

Similar questions