Pivot Table - adding in addition table dimensions


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?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.