Top 10 Percent Paid
SummaryNeed to pull the top 10% paid US staff
Hi, I need to create a query that shows me my top 10% paid staff. The legal definition is:
"In determining which employees are among the highest paid 10 percent, year-to-date earnings are divided by weeks worked by the employee (including weeks in which paid leave was taken). Earnings include wages, premium pay, incentive pay, and nondiscretionary and discretionary bonuses. Earnings do not include incentives whose value is determined at some future date, e.g., stock options, or benefits or perquisites."
Does anyone have any kind of analysis or data model that pulls this?