Count vendors with one order

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

Hi David,

maybe you can try this solution?

COUNT(CASE WHEN LEFT(PU_COUNT(“LFA1”, “EKPO”.“EBELN”)||‘XXX’||“LFA1”.“LIFNR”,4)=‘1XXX’
THEN “LFA1”.“LIFNR” ELSE NULL END)

Combine the number of cases with || XXX and || the vendor number. XXX is to seperate the number of cases from the vendor number