The New Pivot Table Feature In Numbers

The latest version of Mac Numbers adds a new Pivot Table feature. You can now quickly and easily create pivot tables based on the data of another table. Use pivot tables to visualize information in different ways.

Comments: 15 Responses to “The New Pivot Table Feature In Numbers”

    Jasper
    3 weeks ago

    Do you know if there is a way to save a Pivot Table as a kind of template to apply to new files? I’m currently batch processing.

    All I can think of is: 1. duplicate the first Numbers file that contains the set-up Pivot Table; 2. Paste in the next data set; 3. Refresh the Pivot Table; 4. Save with a new, appropriate name.

    If you’ve any more elegant ideas, I’m all ears!

    3 weeks ago

    Jasper: Just create a normal template like you would in any other situation. File, Save as Template.

    Jane
    3 weeks ago

    Thank you and this is very useful, just in time for me business wise.

    JC Blanchard
    3 weeks ago

    Very powerful tool and very well explained. Thank you!

    Kent
    3 weeks ago

    thank you. very useful!

    Ian
    2 weeks ago

    Hi, Gary, I’d be interested to know if you are aware of a real reason why Apple have excluded Catalina from this upgrade? My Late 2012 iMac is perfectly cable of using Pivot Tables on some very large datasets in Excel so why not in Numbers?

    2 weeks ago

    Ian: I don’t know. But I can guess that there are other features, perhaps from other recent updates, that require Big Sur or newer so you can’t upgrade to the latest version.

    Ian
    2 weeks ago

    Gary, thank you. I guess, it just seems odd that I can run 11.1 but not 11.2, I might have a bit more accepting had it been more of a major release. I now just need Apple to release the new larger iMac :-)

    Ray Johnston
    2 weeks ago

    Hi, Gary. I, too, was excited to see the Pivot table addition to Numbers, and sad to see that it was not accessible via Numbers 11.1 on my old iMac running Catalina 10.15.7 . Maybe later, or when I finally spring for the new iMac.

    It seems like creating a Pivot table is a “once and done” operation. I haven’t found an easy way to modify the Pivot table on my iPhone until I get what I want. Am I missing something? My memory isn’t as good as it used to be…

    2 weeks ago

    Ray: Not sure what you are looking for in terms of modifying the pivot table. But I show lots of ways to modify them in this video.

    Keith Flanagan
    2 weeks ago

    Have you tried pivot charts?

    Ray
    2 weeks ago

    When you begin work, creating a Pivot table, a dialog opens that lets you move features around, then you open the table you’ve created. Is there a way to get back to that original dialog without starting over?

    Ray
    2 weeks ago

    My iPhone version doesn’t show all the menus and features on the same Sheet as the Pivot result like it does on your Mac, Gary. Its an iPhone 11 running IOS 15.0. Hmmm, thought I updated that… Now it says 15.0.1 is available, with a few bug fixes. Installing the update now. I apologize if this was the problem. I really enjoy your demos!!!

    Ray
    2 weeks ago

    OK, that helps, a lot. On my iPad can display the Pivot selection option to the side of the Pivot table, and move items around. The exact movements are not quite the same, but they work. Thanks, Gary

    Gene
    2 days ago

    Great video. It appears that the pivot table functions in Numbers is more intuitive than it is (was) in Excel although it’s been a long time since I worked in Excel. Thanks for a professionally done video that is incredibly instructive!

Leave a New Comment Related to "The New Pivot Table Feature In Numbers"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)