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?