Take Control of Numbers, 3rd Edition

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 ...