Help with Expression

[#1]

My data that I have attached provides an

agent name,

unique sale #,

hire date of the agent

and the date of the sale. 

I need to provide an analysis that will allow me to show a count of sales per week.  However I need to exclude data where the agent was hired within the last 60 days in relation to the date dimension.

Any guidance would be appreciated.  I have attached my data table in an excel spreadsheet.

Thanks!

[dmohanty]

you can use something like in Set Analysis:

Count( { $<HireDate<60>} Sale#)

[#3]

Create a variable vagentdate as "=date(Today() - 60)" so that you can configure the number any time and have the expression as  count({<[Agent Hire Date] = {'>$(vagentdate)'}>}[Unique Sale ID]) . This will give the sales count of a agent whose hire data is 60 days before today.