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.
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
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
Thanks for the answer. Sounds a bit silly to me... the issue, not your answer!
Numbers for Mac: grand totals of a pivot table to be the first column
