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.