Rank Question

[vikasmahajan]

Hii,

I have following expression to calculate Top nos group1 wise 

IF(Aggr(Rank(sum([Amt]),4),[Group1])<=vTopNos,[Group1]))

Now I want to calculate top nos using monthname it is linked to calendar

How to calculate rank with 2 dimensions.

Vikas

[sasiparupudi1]

this?

IF(rank(Aggr(sum([Amt]),[Group1],[Month]),4)<=vTopNos,[Group1]))

[MK_QSL]

Dimension

Field1

Field2

Expression

SUM(Aggr(IF(Rank(SUM(FieldName),4)<=vTopNos,SUM(FieldName),Field1,Field2))

[Kushal_Chawda]

Dimensions

1) MonthName

2) Aggr(IF(Rank(SUM([Amt]),4)<=vTopNos,[Group1],MonthName,[Group1])

Expression

=sum([Amt])

[vikasmahajan]

Thanks for reply I have resolved it by storing top nos ids in variable and used same in set analysis.

V_VAL:

=CONCAT(IF(Aggr(Rank(sum([Amount]),4),[Group1])<=vTopNos,[Group1]),',')

used in set analysis like  Sum({< Amount = {'XYZ'},[Group1]={$(=V_VAL)} >} Amount)

Vikas