Set Analysis: returning count(distinct State) where count(Distinct State)>=10

[awqvuserneo]

Hi folks,

Would you kindly help me with converting this "IF" statement to set analysis? (Assuming I will need to display it in Pivot Chart" instead of "Straight Chart")

=If(count(Distinct State) >= 10, count(Distinct State), 0)

As the dimension, I will have the list of Countries. I would expect to have the result as follows:

I appreciate everyone's help on this.

Thanks in advance,

Anton

[swuehl · Accepted solution]

Maybe like

=count({<Country = {"=count(DISTINCT State)>=10"}>} DISTINCT State)

[#3]

Hi,

I would do:

count({<State ={"count(distinct State)> 10"} distinct State)

Try this

Fabrice

[awqvuserneo]

Thanks swuehl & Fabrice for your quick respond. It works!