Filtering yrs of data and sales person

[#1]

Hi,

I'm a newbie, I'm trying to figure out how to

•        Read only the current 3 years of data using a variable

•        Read only salesmen (all employees who have sales) from Employees table

See attached my first attempt.

Thanks

Cheers

[hic]

You could for instance do:

Let vToday = Num( Today() );

Transactions:
Load
TransactionDate,
SalesManID as EmployeeID,
…
resident TransactionTable
Where TransactionDate >= AddMonths($(vToday), -36) ;

Salesmen:
Left Keep (Transactions)
Load
EmployeeID,
…
resident Employees ;

[#3]

Hi Hendric,

Thanks you so much.  I'm going to try it out.

Cheers

Rash