Risk based sampling

[JingYih_Herbalife]

Example:

I have 30 employees, each with 20 expense report numbers, each report number 5 types of expenses attached to them, all with different amount spent. Hence a total of 3000 line items. Of the 3000 line items I want to samples, ensuring that each employee with at least each expense type that has the highest amount spent, without overlapping reports, to be selected as my samples. 

[drew9]

Hi @JingYih_Herbalife ,

I think an iterative macro will be your solution, but can you elaborate further? For your sample, do you want the highest amount spent for each of the 5 expense types for all 30 employees (150 records)?