Sigma allows you to group or ‘pivot’ data on the fly. Learn how to easily group your data and create aggregate columns to analyze your groupings.
- On the right hand side of the screen, find the name of the column that you would like to Group By. Drag the column up to the box that says ‘Drop Grouping Key Here’.
- Using the column menu, accessed by clicking the arrow on the right hand side of the column names at the top or side of the worksheet, you can easily create an aggregate column. When you create an aggregate column, it automatically nests under the next level Group.
If you Group by Holiday, and then create an aggregate column that sums your sales data, the new column will display the total sales per Holiday.
- You can create additional groups as well. Locate the name of the column you want to group by in the list of column names on the right hand side of your screen. Click and drag the column name up above the Base Columns list, and an option to add a new level will appear.
Your Worksheet will now show you two levels of data groupings. You can create aggregate columns of data under all of the group levels.