need help on aggr()!!

[satishqlik]

Hello Viewers,

I want to show only year wise top performers of the last 5yrs.

So my output would be like this

eid	nam	yr1	sal1
1	a	2010	600
2	b	2011	900
3	c	2012	1200
4	d	2013	1500
5	e	2014	1800

attached below xl for your reference.

Plz suggest how can I achieve this?

Any advice would be appreciated. Thanks in advance!!!

[petter · Accepted solution]

You don't need Aggr() for this one.

Just have:

dimension:     yr1

expression 1: Max(sal1)

expression 2: FirstSortedValue( name, -sal1 )

In a straight table.

[satishqlik]

yes that's exactly am looking for and thanks petter for your quick response.!

[petter]

happy to be of help

[pratap6699]

sum({<numyear={">=$(=Max(numyear -4))<=$(=Max(numyear))"}>}sales)

it should be your requirement try it once