Pivot tables are a great way to summarize data by grouping it into rows and columns and then outputting the results of a calculation such as sum or count for each data grouping. Most popular spreadsheet tools require a set up process for pivot tables, that acts a barrier to entry for this amazing tool. At Gigasheet, we want everyone to be a data expert, so we made pivot tables easy. Best of all the scale well beyond the limits of traditional spreadsheets.
How easy? Well, simply click the "Pivot Mode" toggle to activate a pivot table.
Once in pivot table mode, will notice the raw data in your grid disappears. Gigasheet will populate your screen with aggregations once you populate all 3 boxes of the pivot table. To do this, simply grab indiviual columns and drag them down into the three boxes on the right pane, creating groups and aggregations. The fields are:
Once you have all three populated, you will notice that the grid is populated with calculated values instead of raw data.
You can add multiple fields to the Row Groups box, creating groups within groups. Only one field can be added to the Column labels box.
Pro Tip: If you want to reorder values across the column groupings, just drag them into the desired order.
Here is an example of a populated pivot table on Olympic gold medalists.
If you want to change the calculation, click on the field in the Sum of Values box. This will make a box appear where you can choose a different calculation for your aggregation.
For numeric fields, the default calculation is a sum, or total. For text fields, the default calculation is a count. Change your calculation as many times as you need in order to get the answers you need from your pivot table! Check out the video below to see big data pivot tables in action.