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
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
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
SG,
Thank you very much! Your help is much appreciated and has already help me.
Redacted.
Barry
Numbers Pivot Tables
