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.