![]() ![]() Maybe you’ve been doing freelance work and you’ve downloaded all of your income and expense and you want to figure out where your income is coming from by category. ![]() Maybe you’re the manager of a large city’s intramural sports teams and you’ve got detailed data about the players, the sports they’re playing, the field names, and the coaches and you need situational awareness in case a storm is coming through town on how to contact people efficiently. Perhaps you’re a system admin at a university and have a 3000 line spreadsheet with user IDs, class names, instructors, and testing requirements and you need to condense this down to some actionable information. The problem to be solved, in its simplest form, is that you have a giant pile of data and you want to get information out of it. ![]() I realize, though, that this opening statement absolutely requires an immediate pause to explain first the problem to be solved, then an explanation of what pivot tables are and how they solve the problem, and then finally we can explore pivot tables in Numbers. It’s a well-known fact that I am wild about pivot tables. On Tuesday I was delighted to hear from many Internet and real-life friends that Apple has added pivot tables to their Numbers app.
0 Comments
Leave a Reply. |