Count if count of a dimension is less than 1

[ugurarslan]

Dear,

I have a table where I display the count of invoices per customer.  The expression I use is  count(distinct[Invoice Nbr]).

Now the table shows the following:

Customer	Count of invoices
ID A	1
ID BE	4
ID R	3
ID RO	5
ID F	2
ID Z	1

In the table I would like the table to show/display me all customers where the count of invoices is less than 2. 

Example of how the table should look like:

Property	Count of invoices
ID A	1
ID Z	1

Please help me, thanks

Ugur

[pradosh_thakur]

in script use a where condition , It will do the job

[ugurarslan]

Hi Pradosh, I do not have a script, we work with enterprise so I need to do it in the table itself.

Ugur

[pradosh_thakur]

in UI

IF(Count(distinct[Invoice Nbr])<2,count(distinct[Invoice Nbr]),0)
and supress zero.

[pradosh_thakur]

IF(Count(distinct[Invoice Nbr])<2,count(distinct[Invoice Nbr]),0)
and supress zero.

[ugurarslan]

Thanks Pradosh, how do I suppress zero?

[ugurarslan]

Hi, this unfortunately didn't work...

[pradosh_thakur]

please show the output screenshot