Month Wise max data

[shiveshsingh]

Hi guys

I need month wise max data, sample data is shared below

PLAYER	MONTH	RUN
A	MONTH1	10
A	MONTH2	20
A	MONTH3	13
B	MONTH1	14
B	MONTH2	16
B	MONTH3	40
C	MONTH1	45
C	MONTH2	60
C	MONTH3	1

output:

Month	Player	Run
MONTH1	C	45
MONTH2	C	60
MONTH3	B	40

trying with expression but is it now working : SUM(AGGR(MAX(SUM(RUN)),MONTH,PLAYER))

[tresesco]

Straight table

Dim : Month

Exp 1 (Player) : FirstSortedValue( distinct Player, -Run)

Exp 2 (Run) : Max(Run)

[shreya_nadkarni]

Hi tresesco,

Wanted to know for this scenario if there are two dimensions Player and Month.

How can we write 1 expression in order to get the output.is it possible? Thanks

[shiveshsingh]

Thanks tresesco, Can we build expression using AGGR function?

[tresesco]

You can. Is there any specific reason why you would like to use aggr() here? In general, thumb rule is - avoid using aggr() wherever you can.