R
rpboll
I am looking for a query that accounts for the last three of any group
by date. If I have a data sample as follows:
Unit Value Date
a 10 09/18/2005
a 12 10/17/2005
a 14 11/11/2005
a 20 11/21/2005
a 19 12/23/2005
b 19 10/14/2005
b 14 12/17/2005
b 18 02/10/2006
b 20 03/13/2006
b 21 03/29/2006
Results (last three dates average)
Unit Value
b 20
a 18
Any help with this greatly appreciated!
RPBOLL
by date. If I have a data sample as follows:
Unit Value Date
a 10 09/18/2005
a 12 10/17/2005
a 14 11/11/2005
a 20 11/21/2005
a 19 12/23/2005
b 19 10/14/2005
b 14 12/17/2005
b 18 02/10/2006
b 20 03/13/2006
b 21 03/29/2006
Results (last three dates average)
Unit Value
b 20
a 18
Any help with this greatly appreciated!
RPBOLL