Have a new Mac and am delighted that Numbers now supports pivot tables. When in a pivot table, how can you add rows/columns to allow customizing calculations on the resultant table summary?
iMac 24″, macOS 11.6
A pivot table screen will not allow you to add rows or columns. Therefore you cannot add formulas to use that data without copying the PT to a new sheet for doing the analysis. When you refresh the PT data you have to copy it again to the workable sheet. Why can't the pivot table itself allow the row/column addition to permit the customized analysis?
Hello denJ138,
From your post it appears you are looking for information on adding rows/columns in a pivot table in Numbers.
Take a look at the information outlined here: Intro to pivot tables in Numbers on Mac - Apple Support
Cheers.
Hello denJ138,
Please keep in mind that these forums are other users like yourself trying to help each other out.
If you would like to make a suggestion to Apple regarding their products or a feature on an Apple product, the best way to do that is to go here: Product Feedback - Apple
Have a good day.
Numbers pivot table: how can I add rows/columns to customize calculations?
