Above function with 2 dimensions

[#1]

Hi All,

Have a table with having 3 fields..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

Output:

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

Here am attaching the Qvw for the same which i tried.

Basically every month having 4 type of ratings and their activity.

Want to show for jan month activity should show in feb activity and feb activity should show in Mar activity....

I have been used some functions with combination of above but am not getting correct result.

Thanks in advance...

[swuehl]

You've almost done it.

Just change the order of aggr dimensions

only( aggr (above(sum( {$<month=,rating=>}active),1,4),rating,month))

[effinty2112]

Hello,

Maybe:

month	rating	sum(active)	above(TOTAL sum(active),4)
		318
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

Just ensure that your table is sorted by month then rating.

Regards

Andrew