how to get sum over rank.

[#1]

Hi,

I have two tables like...

Sn    Amount   mark

1        300         H

2        400         H

3        600         H

4        400         H

5        290         H

6        100         H

i have a input box in which we enter rank form....to.....

according to rank input i want sum of amount having mark H.please help

regards,

Piyush

[MK_QSL]

Dimension as Calculated Dimension

vTOP is your input field or variable

IF(Aggr(RANK(SUM(Amount),4),Sn)<=$(vTOP), Sn)

or

IF(Aggr(RANK(SUM(Amount),4),Sn, mark)<=$(vTOP), Sn)

Expression

=SUM(Amount)

[#3]

Hi Manish,

It will be like IF(Aggr(RANK(SUM({<{Mark}={'H'}>}Amount),Sn)=<$(vtop),Sn)...please suggest if this is right.

[MK_QSL]

Yes... The same set analysis you need to use in expression

[#5]

hi

see attachment according to your requirement, hope this helps you.

Regards

[MK_QSL]

Please check enclosed file...

[#7]

Hi,

Didn't get your attachment.

Regards,

Piyush