get minimum dimension of bottom ranking

[cafcptg2011]

Hi,

I need to get the minimum region dimension of bottom ranking, in this case is the Region e. How can I accomplish that?

I have attached a qvw file to help figure out my pb more easily.

Could anyone please help on this?

Thanks in advance,

CAFC

[anlonghi2]

You are right, the formula was wrong because I used Orders instead of Sales... you need to change both formulas as following:

Please look at attached qvw

Best regards

Andrea

[cafcptg2011]

I need to put in the expression the region like that (and will not to selected by user):

=aggr(rank( sum( {$<Region={'B'}>} Sales),4,1),Region) or =aggr(rank( sum( {$<Region={'B'}, Orders ={'>0'} >}  Sales),4,1),Region)

but it returns always 1 and should be 9.

thanks