Analyze Data with Categories

In this very hands-on chapter, after getting acquainted with the concept of categories, you’ll Create a Sample Category Table so you’ll have something with which to work. I’ll show you how to Define and View Categories and then Add a Summary Function. Finally, there’s a list of brief but important facts in More About Categories.

What are categories? Numbers’ answer to Excel’s pivot tables turns a mild-mannered table into a super information engine that reorders and groups data, adding subtotals, totals and other statistics—all in a format that lets you collapse and expand the groups and sub-groups.

See the Categories Advantage

Say you’re running a school fundraiser and track orders in a table like the one in Figure ...

Get Take Control of Numbers, 3rd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.