Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like
=count({<Country = {"=count(DISTINCT State)>=10"}>} DISTINCT State)
Maybe like
=count({<Country = {"=count(DISTINCT State)>=10"}>} DISTINCT State)
Hi,
I would do:
count({<State ={"count(distinct State)> 10"} distinct State)
Try this
Fabrice
Thanks swuehl & Fabrice for your quick respond. It works!