how to create pivot table in mac numbers

In my example I've got product, I've got months, I've got amount. It depends upon what type of data you've got. So here we've got January, February, and March. Then it's going to put it together in months. Now you can change this by saying instead of grouping by product, let's group by date. I can reveal bananas and I can close them as well. Now you can click here to reveal all the data under this. So you have apples, oranges, bananas, and peaches. Either way it's going to get you to the same place which is that it's going to group together all of the different products. So under Category you can add a Category and I can pick the Product column. You could also go on the right side here for Organize. One way to do it would be to select a table here, click the little reveal Commands or pull-down menu right there, and select Add Category for Product for this column. Say we wanted to visualize things grouped together by product. So you can see there's apples, there's oranges, there's bananas. They're not even sorted or anything like that. Here it's got a product column here on the left and each row is a record in here. But now we have it back in version 5.2 of Numbers there's something called Smart Categories.

Then it was removed when Numbers was rewritten.

You can do that in Numbers using something called Categories prior to 2013. This is a technique used in Microsoft Excel to allow you to visualize data in different ways. Video Transcript: So one of the most requested features in Numbers is something called Pivot Tables. Check out Using Smart Categories (Pivot Tables) in Mac Numbers at YouTube for closed captioning and more options.

How to create pivot table in mac numbers