Show rows if criteria has not been seen in past month

[#1]

I am trying to do some exception analysis similar to the scenario in this post. I am trying to find where an employee has charged a new Charge Code like in the underlined row on 11/17/2011. Has an employee charged this Charge Code in the past month?

I have the following data (column names in first row)

Employee Name, Timesheet Date, Charge Code, Account Name, Amount

Joe Smith, 11/10/2011, 0010, Labor - Direct, 1000

Joe Smith, 11/10/2011, 0010, Labor - Haz, 400

Joe Smith, 11/10/2011, 0010, Labor - Post, 400

Joe Smith, 11/10/2011, 0015, Labor - Direct, 2000

Joe Smith, 11/17/2011, 0010, Labor - Direct, 2500

Joe Smith, 11/17/2011, 0055, Labor - Direct, 2500

Joe Smith, 11/3/2011, 0010, Labor - Direct, 1200

Joe Smith, 11/3/2011, 0010, Labor - Haz, 400

Joe Smith, 11/3/2011, 0010, Labor - Post, 400

Steve Jones, 11/10/2011, 0015, Labor - Direct, 1700

Steve Jones, 11/03/2011, 0015, Labor - Direct, 2000

Thanks

[#2]

Hi Rick try with pivot table  with following dimension:

if(aggr(max([Charge Code]),[Employee Name],(fecha)),[Employee Name],[Employee Name])

and following expression:

max([Charge Code]),

date(max(fecha))

let me know if it works