Hello! I am hoping someone can help me find a solution to my issue. I am trying to create a formula (or some other solution) that will take the data from our sales events (the person that worked it, how much was sold in , how long the event was in days, and what sales quarter it occurred in) and output an average for the person that worked during that quarter. Each person would have worked multiple events in that quarter. So the formula basically would calculate per person the total sold / total days worked in sales quarter 1.
I am able to get Airtable to calculate it in a Pivot Table block, but can’t get that data out of the pivot table block to make it useful in other formulas. We need to take that average to then project their sales at the next event.
Any help would be much appreciated!