Optimizing Commission Structures

Introduction to Commission Structures

Discount Structure Setup

Calculating Yearly Breakpoints

Query and Rollup for Sales Data

Current Discount Calculation and Reflection

The speaker discusses the structure of a commission table, detailing the steps for each year, discount percentages, and the relationship between discount structures and partner tables. They express uncertainty about the complexity of their current setup and seek a more efficient method for managing commission calculations.

Drop · Glide - Google Chrome