colkak.blogg.se

So I could say, basically, what's the sums if the product column is equal to apples. So only take into account the rows with apples in them and then count up the number sold. A typical thing you may want to do with a pivot table is to say, okay how many apples have been sold total in this table. You've got the numbers sold and the price. So you have apples, apples, apples, and oranges, oranges, oranges. You can see a bunch of products that are repeated. So here's a table that's got a list of sales. So let's simulate a typical use of pivot tables in the current version of Numbers. You can actually do that using some formulas in Numbers. However, what people are mostly looking for when they're doing pivot tables is being able to get a specific type of data from a table. Prior to 2013, in the original version of Numbers, you could do something called Categories which was kind of the same thing. You can't really do pivot tables in Numbers. Pivot tables are kind of an expert level technique that people commonly do in Microsoft Excel. Video Transcript: One of the most common things that spreadsheet experts ask about Numbers is can you do pivot tables with them. Check out Simulating Pivot Tables In Numbers at YouTube for closed captioning and more options.