Skip to main content

Hi! 

I have some pivots in Excel that I’m attempting to re-create in Airtable. It has multi-level categories in the rows (Region, Country) and then 4 different metrics that I convert to a %. (In Progress, Successfully Completed, Previous Week Successfully Completed, and Increase Amount) I have all of the line-detailed data that you’d need to get this in Excel (Record ID, Region, Country, and binary 1/0 for In Progress, Successfully Completed, Previous Week Successfully Completed, and Increase Amount.) 

 

I cannot for the life of me figure out how to replicate this in Airtable and then add it to an interface. The closest I’ve been able to get is a grouped view of the data that I show as a grid and then removing the “0”s and changing the values of those metrics to be % Filled. This is almost fine, but it doesn’t stay grouped and expands too much. Is there a better way to do this? 

 

Hi ​@laurenagrigento,

To create a pivot table in Airtable, you need to “flatten” all of your data down to just 3 fields.

Airtable won’t support 4 fields, which is what you are looking for. You are looking for: “Region”, “Country”, “Status”, and “% completed”.

So you would need to create 2 different pivot tables:

  1. One pivot table could support “Region”, “Status”, and “% completed”.
  2. The other pivot table could support “Country”, “Status”, and “% completed”.

However, you first need to setup your data in Airtable in the proper way to support building a pivot table.

It’s a little tricky to setup your Airtable data in the proper way for a pivot table — and it’s much different than setting up a pivot table in Excel — so I show how to do exactly what you’re looking to do in this Airtable podcast episode.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

 

Terms & Conditions