Appreciate guidance on how to edit / change column name in Pivot table (Mac numbers).
example Apple (sum), Sale (average), Store (count) etc to Apple, Orange, Store or something else as preferred
[Re-Titled by Moderator]
MacBook Air 13″, macOS 12.7
Why do you want to change those column names?
As you know doubt know, the main use Pivot Tables is not for final presentation, but to conduct analysis "on the fly" and vary that analysis easily. The ( ) in the column names adds useful information.
If you need to make a nice presentation of the results to show others, then start a new table, select the cells in the Pivot Table, and copy/paste into the new table, where you can edit the column names and other aspects of the appearance to suit your needs.
The time it takes to do that usually is far less than the time you have saved by using a Pivot Table to analyze your data instead of inputing and debugging formulas.
SG
Why do you want to change those column names?
As you know doubt know, the main use Pivot Tables is not for final presentation, but to conduct analysis "on the fly" and vary that analysis easily. The ( ) in the column names adds useful information.
If you need to make a nice presentation of the results to show others, then start a new table, select the cells in the Pivot Table, and copy/paste into the new table, where you can edit the column names and other aspects of the appearance to suit your needs.
The time it takes to do that usually is far less than the time you have saved by using a Pivot Table to analyze your data instead of inputing and debugging formulas.
SG
Thanks. Appreciate your response.
MS Excel had the option to edit the column name and so thought of check if it possible in Numbers as well. If possible it will be more helpful and will simplify the task.
thanks anyways
How do I edit column names in a Numbers Pivot Table?
