Count values (>1) in Pivot Table

[#1]

Hello, I have the following Pivot Table:

What I need is to count in the field # Atenciones (it's an expression) those values > 1 (without expansion)...

But the thing is that if I expand the field Cuenta, I could have 2 & 1 # Atenciones (3 in total).

How could I do that?

Thank you!!

[giakoum]

you need to use the aggr function.

aggr(count(# Atenciones), Categoria, cuenta)

[#3]

And how do I count if those values are >1 using that function? Thanks!

[its_anandrjs]

Hi,

Count the frequency in the load script and use it in expression.

Hope this helps

Thanks & Regards

[giakoum]

if(aggr(count(# Atenciones), Categoria, cuenta) > 1, 'do something', 'do something else')

[#6]

Hi Sam,

Use expression

=if(Count(TOTAL  #Atenciones)>1,Count(TOTAL #Atenciones)

This may help..