Hello everyone,

I want to analyze how many vendors were just created for one order.

What did work?

I created an OLAP table with vendors and a simple case count.

What is not working?

I am not able to count the number of vendors with one case. So, I would like to have a KPI Number of One-Time-Vendors and it should show for example 150.

Can anyone help me with this issue? It should be basically equivalent to an Excel countif.

Thanks in advance.

Best regards,

David