Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Pivot Table - adding in addition table dimensions

Topic Labels: Extensions
350 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi!

I am wondering if there is an ability to add additional data dimensions to Pivot Tables in AirTable.

What I am hoping to accomplish would essentially break down each Rep, and by the dollar amount of potential sales they have in each deal stage, this part of I am able to get set up, however, I would like to show additional data points (such as monthly quota) by each rep.

Ideally, the table would show a row for each rep, the amount of money the rep has in each stage, and then an additional column showing their quota for added context.

I have been able to do this in Excel and Google sheets but adding in additional columns using a “Value as: Column” type function and selecting additional columns from my table.

Any suggestions on how this might equate into AirTable?

0 Replies 0