Average by Group for Max QTR

[vinieme12]

Hi Guys,

Need your help with an expression.

Need to Average Rank for the latest QTR only

So Group1=(9+4+5)/3    <<<3 being latest for Group1

and Group2=(7+5)/2    <<<<4 being latest for Group2

Group	Rec	Name	QTR	RANK
1	1111	AAAAA	1	9
1	1111	AAAAA	3	9
1	2222	BBBBBBBBB	2	8
1	2222	BBBBBBBBB	3	4
1	3333	ccccccccccccccc	3	5
1	3333	ccccccccccccccc	2	6
2	5555	yyyyyyyy	1	9
2	5555	yyyyyyyy	4	7
2	6666	iiiiiiiiiii	1	6
2	6666	iiiiiiiiiii	2	4
2	6666	iiiiiiiiiii	3	4
2	7777	mmmmmmmmmm	4	5

[jyothish8807]

Thanks a lot.. learned a new thing

Br,

KC

[sunny_talwar]

I am glad I was able to help you learn a new trick