Pazhamalai
How to Build an Airtable Pivot Table with Multiple Columns and Custom Formulas
Airtable's built-in Pivot table takes a single column field, a single row & value field, won't nest and has no support for custom formulas. This guide shows you what's actually possible and how to build a real multi-column pivot you can share.
Key Takeaways
Airtable's Pivot Table interface extension supports just one row field, one column field (Airtable pivot interface) and no direct formula support.
"Multiple columns" in a pivot means multiple column dimensions or multiple value fields. Airtable does not support either of them.
We discuss three different approaches to solve this i.e creating a group formula field, exporting to Sheets and setting up FlexiPage reports.
Workarounds to add multiple columns in Airtable Pivot Table
We'll see three ways to approximate a multi-column pivot with formulas in Airtable.
Say our goal is to create a pivot table for sales performance report, with two columns of Region and Product Category. A new formula field can be added to Airtable table that combines these two fields (formula: '{Region} - {Product Category}'). And then group by column in Pivot Table can be pointed to this new field. The downside is that we still won't have support for custom formulas in this approach. If your usecase only involves computing standard aggregation for multiple-columns, this approach might be handy, but it is not a full fledged solution and not ideal to share with external clients.
Exporting to Sheets or Excel unlocks real pivots, but now the problem shifts to how to transfer relevant data to excel and create reports in an automated way. For a monthly report, a fully automated reporting system needs to sync relevant airtable data to an excel sheet. A pivot table in excel can then be configured to operate from this data. NOTE: Sync may not be necessary, rather find records + google sheet append row action would work fine, if your goal is to create static reports at a particular frequency (monthly / weekly).
Airtable provides native append row action to google sheets. You can schedule the automation to run month start, use Find Records action to fetch past month data and append it as rows to google sheets. Tools like Zapier, Make or WhaleSync can also be used to export relevant data to a specific sheet automatically. An alternate approach would be to download the data manually from an Airtable view and then uploading it to a spreadsheet software.
The trick to automation here is that, always sync the data with the sheet Pivot Table relies on, so you don't have to again configure Pivot Table in google sheets. Once relevant data is exported (Pivot table would be auto-updated), then use app script to generate pdf document and store it in google drive.
FlexiPage builds the pivot Airtable's extension can't: multiple row levels, multiple column dimensions, several value fields in one view and custom forumulas over value fields. FlexiPage's pivot table directly connects with Airtable tables, so there is no overhead of exporting Airtable data to google sheets. This whole pivot table configuration inside FlexiPage, can be exported as a PDF document in an automated way using Airtable automations itself.
In FlexiPage template,
Add the Pivot block to your FlexiPage template and connect it to your table.
Set your row dimensions. Pick one or nest several — Region, then Product category — for an indented, grouped left axis.
Add a column dimension. This is the axis the native extension caps at one; here it's just another field, like Product Category.
Add multiple value fields. Drop in Revenue and Units, each with its own aggregation and number format.
Turn on subtotals per row group so each region rolls up automatically.
Want to see it charted too? Pair it with FlexiPage's chart components which also connects to Airtable tables.
Real reports rarely stop at raw counts. FlexiPage can add calculated value fields — variance, growth, percent-of-total — computed right inside the pivot.
Set a date field as your column dimension and choose a granularity — month, quarter, year — and FlexiPage buckets records into period columns for you. Then add a calculated value field with a formula that references sibling columns, so a "% change" or "variance" column appears next to the numbers it compares.
Exporting your multi-column pivot to a shareable PDF
Airtable's native Pivot Table interface does supprot printing. But it is very limited in scope. Make sure to choose landscape tabloid page setup to render the Pivot Table in full for the print. Currently there is no way to setup automated printing of Airtable's Pivot Table interface element. Multi-page
FlexiPage renders your multi-column pivot as a true multi-page PDF, with full automation support using Airtable automation.
Because FlexiPage runs inside Airtable, export is one click: generate the PDF to download, or send it to an attachment field from an automation for scheduled monthly reports. Your column dimensions, value fields, subtotals, and formatting all carry through to the document.
Ready to build a pivot Airtable's native tools can't? Install FlexiPage from the Airtable Marketplace and turn your Airtable data into a shareable report.
Frequently Asked Questions
Can Airtable's Pivot Table extension export to PDF?
Airtable's interface Pivot Table component allows printing support. Click on "Expand Pivot Table" in Airtable interfaces then proceed to print the page. Make sure to use tabloid page with landscape mode to cover all the columns.
How many column fields can a native Airtable pivot use?
One. Airtable's Pivot Table extension takes a single row field and a single column field, with no nesting of multiple column dimensions. Multiple column groups remain an open, long-standing request in Airtable's community forums.
What's the difference between multiple columns and multiple values in a pivot?
Multiple column dimensions add more categories across the top (Quarter, then Product). Multiple value fields add more numbers inside each cell (Revenue and Units). Native Airtable Pivot Table supports one column and one value field.
Do I have to leave Airtable to get a proper pivot table?
Not anymore. Exporting to Google Sheets or Excel works but breaks your live data link. FlexiPage runs as an Airtable extension, so 500,000+ organizations' worth of data (Fueler, 2026) can stay in the base while you build multi-column pivots and export PDFs.
Conclusion
Airtable is brilliant at storing relational data, but its native pivot stops at one column and can't produce a document.
Native pivots: one row field, one column field with partial printing support.
With automated sync to spreadhseet it is possible to configure Pivot Table much more. But requires lot of initial effort to setup the sync, pivot table configuration and app script to create pdf reports.
FlexiPage overcomes the limitations of both the approaches. Providing multi-column pivot table that directly connects with Airtable tables, as well as complete support for automation to render clean multi-page PDF.
Sources
Airtable Support, "Pivot Table extension," retrieved 2026-07-27, https://support.airtable.com/docs/pivot-table-extension
Airtable Community, "Pivot table multiple column groups" (product idea), retrieved 2026-07-27, https://community.airtable.com/legacy-product-ideas-75/pivot-table-multiple-column-groups-42598