Above function with 2 dimensions

[hari8088]

Hi All,

I have a data like below......

month	rating	active
jan	A	21
jan	B	22
jan	C	23
jan	D	24
feb	A	25
feb	B	26
feb	C	27
feb	D	28
mar	A	29
mar	B	30
mar	C	31
mar	D	32

Here each month having 4 type of ratings and their activities.

The out put which i required like below....

month	rating	active	Outputresult field
jan	A	21
jan	B	22
jan	C	23
jan	D	24
feb	A	25	21
feb	B	26	22
feb	C	27	23
feb	D	28	24
mar	A	29	25
mar	B	30	26
mar	C	31	27
mar	D	32	28

have been tried different type of functions with combination of above but not getting proper output.

Am attaching the qvw for the same.

Thanks in advance....

[antoniotiman]

See Attachment.

Regards,

Antonio

[hari8088]

Hi Antonio,

Thanks for your solution.....It's working  fine but instead of back end is this possible in front end in terms of exprssion.

[hari8088 · Accepted solution]

Yes.....I got the solution .

aggr(if(RowNo()>1,Above(active)),rating,month)

if i use above expression in chart it is giving correct result i need.