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