Group Data

Introduction

Groups allow you to quickly segment rows, or pivot in your data sets. Grouping organizes rows by a specified categorical column, and collapses rows that meet the specified criteria. Groups provide similar functionality to traditional pivot tables, but are easier to navigate. To the right of each group you'll see a count of the number of rows within the group.

Ways to Group Data

1. Column selector found in the column header menu.

2. Group Panel found in the menu above the sheet grid.

3. Drag columns into the right-hand panel Row Groups area