Set analysis: how to add a second criteria on a second dimension

[#1]

Hello,

In my set analysis (see picture) I sort the data through the field "sort_param", to keep only the second minimum value.

How could I filter the data to discard the "NV" values ? It would mean, in my example, that the set analysis expression would return the "Istwert" value of the row 3, so 2033.138

Thank you very much !

[swuehl · Accepted solution]

Try

=sum({$<sort_param={$(=min({<[Ziel_Erreichung]-={NV}>}sort_param, 2))}>} Corr_Istwert)

I've added an additional set expression to min() function to exclude the NV value lines.

And I also changes Istwert to Corr_Istwert, since that's the field you are using in your table (gave me some hard seconds to realize...)

Regards,

Stefan

[#3]

You are the king, thank you verry much!