Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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