Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.

Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >

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 for Mac: grand totals of a pivot table to be the first column

Hi everyone, is there a way to move the "grand total" columns from the end of the table to the beginning? As you can see the table is a pretty large one (doesn't fit the screen) and first I want to see the total amount, and then (if needed) see how I get that total. Thank you.

Posted on Feb 17, 2023 1:40 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 17, 2023 7:29 AM

There is no way to move Grand Total columns to the left.


But you can easily have two Pivot Tables based on the same data table.


You could have one Pivot Table show just the grand totals, with the other showing more columns but no grand total.


You have probably discovered by now that you can click the circled ... to hide grand totals.


SG

2 replies
Question marked as Top-ranking reply

Feb 17, 2023 7:29 AM in response to SignorSmith

There is no way to move Grand Total columns to the left.


But you can easily have two Pivot Tables based on the same data table.


You could have one Pivot Table show just the grand totals, with the other showing more columns but no grand total.


You have probably discovered by now that you can click the circled ... to hide grand totals.


SG

Numbers for Mac: grand totals of a pivot table to be the first column

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