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.

Pivot tables in numbers?

Is there Pivot tables in numbers, if not how to compensate it with what?


Posted on Feb 7, 2020 10:10 PM

Reply
Question marked as Top-ranking reply

Posted on Feb 8, 2020 12:41 AM

Hi Orson,


In Numbers, Categories are the equivalent to pivot tables.

Menu > Help > categories



Click on a table to make it active.

Organise > Categories > Add a Category





Explore the options under the cogwheel.



Please call back with questions.


Regards,

Ian.

4 replies

Feb 9, 2020 11:06 PM in response to orson177

The 'Categories' feature in Numbers is most similar to 'Subtotal' in Excel (under the Data tab in the ribbon).


It doesn't do the kind of "cross tab" summaries that are central to Pivot Tables in Excel. For those, you need to use SUMIFS and COUNTIFS, just the way you used to have to do in Excel before it added Pivot Tables.


Nevertheless, 'Categories' is a very powerful and handy feature that may do what you want, all without having to enter a formula.


SG




Pivot tables in numbers?

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