For the second part I want to take the average of proportion I think. I wasn't sure if just doing AVG(%) would be enough or if I have to use LOD considering how the table is set up.
Not sure if I am getting the desired answer for the first one with the calculation you are showing.
To elaborate I want the table to ultimately look like below when I do the % calc
Date Category Supervisor Location Agent ID Agent Name Sold Daily Total Daily Proportion 1/17/2017 Furniture Moore Orlando 1 DIXON 10 15 0.667 1/17/2017 Office Supplies Moore Orlando 1 DIXON 5 15 0.33 1/17/2017 Kitchen Supplies Moore Orlando 1 DIXON 0 15 0
I think what I am struggling with is, is drilling the proportion down to each category for each agent and location.