¿How can I create pivot tables on Numbers?

You can't, Pivot Tables (like many other useful things) is something that Numbers can't do.

You may find that other posters may have a workaround for the issue, I also have one. Don't use Numbers unless there is no alternative (there are many)

Pivot Tables (and Charts) in Excel are really nice for heavy-duty data analysis. However, if you simply need to construct a summary table of counts or sums, you can do that easily in Numbers like this:

If you look up SUMIFS in the function browser you'll see how it works. It's much easier than it looks.

The first argument within the () is the column you want to sum. The following arguments are column-condition pairs, where each condition applies to the column just before it.

So the formula here in B2 is saying, add up all the numbers in column C of the data table (the first argument) where the value in column E of the Data table is the same as the value in A2 (the first column-condition pair) and the value in column D of the Data table is the same as the value in B1 (a second column-condition pair). You can add more column-condition pairs as needed.

This (which you can also do in Excel, by the way) requires a little more setup than a pivot table but you get to the same place. And you can use the new summary table as a basis for further calculations and for charts.

If you are doing counts instead of sums, use COUNTIFS instead of SUMIFS.

SG

I use Numbers at home and Excel at work, Pivot tables are basically Summary tables based on criteria that you place in the header column or row. In essence Excel deos the Counitfs or Sumifs for you using the column and row headers, hiding the formulas from you.

If you know how to use SUMIFS, COUNTIFS, AVERAGIFS and their singular equivalent (bascially without the S on the end), you can make all the same tables in Numbers. You just enter a single formula and fill your cells.

I can now do this faster than the extra steps in a pivot table (sometimes 🙂). I also like having the control of the formulas myself to tweak as a might need to. It also gives me the flexability to really put more complex summaries together for my managers. (who typically take the numbers from their pivot tables, and copy/pastevalues into another sheet to manipulate the data further.)

Here is the guide for numbers formulas and functions

Hope you find the best solution to fit your needs,

Jason