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

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.