Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Count(DISTINCT {<[Invoice Nbr] = {"=Count(DISTINCT [Invoice Nbr]) = 1"}>} [Invoice Nbr])
try this
if( count(distinct[Invoice Nbr]) < 2, count(distinct[Invoice Nbr]))
and in Data Handling option uncheck include zero values
Regards,
Bhargav