Using lowest selected value in set analysis

[#1]

I have the following data and wish to know how many workers  start work on the first week of any selection. With no selection, therefore only one person starts work on the first week (that is Worker JS on 200313),

I wish to build a table of who manages those starters. I have a straight table with the manager dimension and the expression count(distinct {$<YearWeek = {"=min(YearWeek)"}>} Worker) This gives me 1 for Bill and 2 for Dave. I therefore explored the AGGR function and used count(distinct {$<YearWeek = {"=aggr(min(YearWeek),Manager)"}>} Worker) but with the same results.

Can anyone help on this. In essence I need to use the lowest selected value in set analysis regardless of Dimension

Thanks

Dave

Manager	Worker	YearWeek
Bill	IK	200316
Bill	IK	200317
Bill	IK	200318
Dave	DS	200315
Dave	DS	200316
Dave	DS	200317
Dave	DS	200318
Dave	DS	200319
Dave	DS	200320
Dave	JS	200313
Dave	JS	200314
Dave	JS	200315
Dave	JS	200316
Dave	JS	200317
Dave	JS	200318
Dave	JS	200319

[swuehl · Accepted solution]

Try a set expression using a dollar sign expansion in your set modifier:

=count(distinct {$<YearWeek = {$(=min(YearWeek))}>} Worker)

[#3]

Thank you swuehi for super fast response. That worked a treat