analytics2006
MIS
I am working on a report and need to do the comparison between current type and previous type to monitor user who changes the type within the table except for user “zy5897” or “wy5689”. The report is group by acct# then inv#. I need to output the prev type (tt) with prev date (1/10/07) even though the user is zy5897. I can’t get it to output because I think I have put criteria (account.user <> “zy5897” or account.user <> “wy5689”) in the report>selection formula> records to exclude these two users. I am not sure where I can place the criteria. Can anybody please provide some suggestions on how I should do this? Any help will be greatly appreciated. Thanks.
Table
Acct# inv# type date user
W525 Q8588 tz 2/25/07 wy5689
W525 Q8588 tt 2/20/07 zy5897
W525 Q8588 cc 1/20/07 cx8888
W525 Q8588 tt 1/10/07 zy5897
Output
Acct# inv# prev_type prev_date curr_type date user
w525 Q8588 tt 1/10/07 cc 1/20/07 cx8888
Table
Acct# inv# type date user
W525 Q8588 tz 2/25/07 wy5689
W525 Q8588 tt 2/20/07 zy5897
W525 Q8588 cc 1/20/07 cx8888
W525 Q8588 tt 1/10/07 zy5897
Output
Acct# inv# prev_type prev_date curr_type date user
w525 Q8588 tt 1/10/07 cc 1/20/07 cx8888