How To

Create a Pivot Table With Big Data

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.

The Pivot Mode toggle is all it takes to activate pivot tables

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:

  • Row Groups
  • Sum of Values
  • Column Labels

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.

Pivot table with country Row Groupings, year Column Labels, and Sum of Gold Medals as the calculation.

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.

Similar posts

Thousands of individuals & teams use Gigasheet.

Join Them.
No Code
No Database
No Credit Card
Sign Up Today, Free Forever

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.