A pivot table is a summary of your data, packaged in a chart that lets you report on and explore trends based on your information.
Using Microsoft Excel? Click Here
- Export your data from Casebook or Enter your data into Google Sheets into a range of rows and columns. Every pivot table in Sheets starts with a basic Sheets table, where all your data is housed. To create this table, simply enter your values into a specific set of rows and columns. Use the topmost column to categorize your values by what they represent.
- Highlight the cells in your table to create your pivot table. Once you've entered data into your Sheets worksheet, and sorted it to your liking, highlight the cells you'd like to summarize in a pivot table. Click Data along the top navigation, and select the Pivot Table.
- Drag and drop different fields into the Row Labels and Column Labels areas. This will determine what unique identifier the pivot table will organize your data by.
- Drag and drop a field into the Values area. Once you've established what you're going to organize your data by, your next step is to add in some values by dragging a field into the Values area.
- Adjust your pivot table as needed.
To see these steps in action, check out the video below: