Exclude count and sum values

[#1]

I got three expressions in my chart

if (Count (X) > 1, Count (X), '-') 

if (Sum (XX) > 1, Sum (XX),'-')

if (sum (XXX)> 31, sum (XXX),'-')

I want to show only rows that qualify all the above expressions?

now i have for example:

X          XX          XXX

-          3               -

-          -                -

2          3              32

I want

X          XX          XXX

2          3               32

Daniel

[#2]

Can you share sample data?

[jerem1234]

You can try this for your 3 expressions:

if (Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31, Count (X))

if (Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31, Sum (XX))

if (Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31, Sum (XXX))

or you can try a calculated dimension like:

aggr(only({<YourField = {'=Count (X) > 1 and Sum (XX) > 1 and Sum (XXX)> 31'}>}YourField), YourField)

then with expressions:

count(X)

sum(XX)

sum(XXX)

Hope this helps!