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 Pivot Tables

I would like to know if and when Apple will update the Numbers application so that a pivot table can be moved to any sheet, once it has been made. I would like to have multiple pivot tables on 1 sheet. And to go along with this, when refreshing a pivot table, all other pivot tables should refresh.

I would also like to have real data validation (not a pop-up menu).


MacBook Pro 13″, macOS 12.4

Posted on Jun 26, 2022 7:48 AM

Reply
Question marked as Top-ranking reply

Posted on Jun 26, 2022 8:42 AM

None of your fellow users here know when Apple will next update the Numbers app.


However,


1) A Pivot Table already can be moved to another sheet once it's been created. Just click somewhere in it, then the


symbol at its upper left, type command-c, then click in the canvas of another sheet and command-v to paste.


2) You can already have multiple pivot tables on the same sheet. Just click in the table with the data and from the menu choose Organize > Create Pivot Table > On Current Sheet. You can do that as many times as you like. That can be very helpful for getting different views of your data.


As for refreshing, you have to do that one-by-one. You could go to Numbers > Provide Numbers Feedback and make the case for a 'Refresh All' feature.


You could also provide feedback on data validation, and using data validation to create a "cascading menu" from values in a range of cells. That's very handy in Excel.


SG


3 replies
Question marked as Top-ranking reply

Jun 26, 2022 8:42 AM in response to FlynnMan

None of your fellow users here know when Apple will next update the Numbers app.


However,


1) A Pivot Table already can be moved to another sheet once it's been created. Just click somewhere in it, then the


symbol at its upper left, type command-c, then click in the canvas of another sheet and command-v to paste.


2) You can already have multiple pivot tables on the same sheet. Just click in the table with the data and from the menu choose Organize > Create Pivot Table > On Current Sheet. You can do that as many times as you like. That can be very helpful for getting different views of your data.


As for refreshing, you have to do that one-by-one. You could go to Numbers > Provide Numbers Feedback and make the case for a 'Refresh All' feature.


You could also provide feedback on data validation, and using data validation to create a "cascading menu" from values in a range of cells. That's very handy in Excel.


SG


Numbers Pivot Tables

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