rank and aggr function

[#1]

Hello,

I am working on a aggregation ranking function and i have actual one problem.

i want to calculate my aggregation/ranking only for the [Masch.-Nr.]='01-11' but i tried several set analysis filters but its still not working.

my aggr. looks like

=concat(if(Aggr(rank(min(Aggr(sum(Ist_P)*-1,Woche,[Masch.-Nr.], Jahr))),Woche)<=3, Woche & ' / ' & Ist_P & chr(10)))

and the text box shows

but should show

17 / 1,5

27 / 1,6

26 / 1,7

I tried to set

{<[Masch.-Nr.]={'01-11}>} but not the right result.

[sunny_talwar]

I am not sure how you are getting your expected output? There is not combination for 17 / 1,5, 27 / 1,6 and 26 / 1,7 for your current selection. Are we doing this for your current selection or on unselected data?

Best,

Sunny

[#3]

Hello Sunny,

Maybe this was not clear for the forum, but the combination was only an example, based on the actual data in the qvw it should be 17 / 1,9, 27 / 2,0, 26 / 2,1

Armin