I'm having trouble as I've created this pivot table from a monthly sales table. My calculated field is sum of commission. This funny thing is the first three are correct and the last 2 are way off. Can someone point me in the direction of what to check for? I'm at a loss.
2023 Fiscal Year Progress | ||||||||
Row Labels | Sum of Budget | Sum of Sales | Average of Variance | Sum of Cost | Sum of Gross Profit | Average of Margin | Base rate | Sum of Commission |
Jamie | $70,000 | $94,315 | 34.7% | $60,437 | $33,878 | 35.9% | 0.0700 | 3082.898 |
Matt | $60,000 | $117,607 | 96.0% | $75,491 | $42,116 | 35.8% | 0.1000 | 5475.08 |
Jaime | $27,159 | $16,519 | $10,640 | 39.2% | 0.1000 | 0 | ||
Darcy | $60,000 | $54,463 | -9.2% | $29,875 | $24,588 | 45.1% | 0.1000 | 1441259486 |
Mike | $50,000 | $46,881 | -6.2% | $27,745 | $19,136 | 40.8% | 0.1000 | 852609895.8 |
Grand Total | $240,000 | $340,425 | 41.8% | $210,067 | $130,358 | 39.4% | 0.4700 | 79648.738 |