How to limit rows number?

[#1]

Hi,

Can anyone tell me how to display only these rows that have 'Nie' value in last column?

Thanks

[Miguel_Angel_Baeyens]

Hello,

I'd use set analysis in every expression, so Naleznosc column, for example, would look like the following (I don't have polish characters)

Sum({< [Czy rozliczony] = {'Nie'} >} Amount)

The bold part is the set analysis, which is what you should add to all expressions in chart.

Hope it helps.

[#3]

hello,

you can use set analysis in your expression:

sum( {$ <[Czy rozlyczony] = {'Nie'}> } kwot_rozl)

where $ means current user selections are considered except what is in the <>-brackets.

HtH

Roland

[#4]

Hi,

Thanks. I am not sure if I can use set analysis in each column formula because two columns do not use aggregation

Nale?no?? = only(Nale?no??)

Zobowi?zanie = only (Zobowi?zanie)

Can I still do it without using aggregation?

[Miguel_Angel_Baeyens]

Hi,

Actually, Only() function is an aggregation function. If the field or expresion has more than one value, it will return null. According to this, you can add set analysis to the Only() function:

only({< [Czy rozliczony] = {'Nie'} >} Nale?no??)

Hope that helps