Hi Tobias,

I may have misunderstood your question, but are you suggesting something like this

Where count for Case 1 would be 30, Case 2 would be 30 and Case 3 would be 10....

Here is what you would do for the same situation, take a dimension as

CASE WHEN COMPANY IN ('ABC','BCD') THEN ''CASE 1'

WHEN COMPANY IN ('CDE','DEF') THEN ''CASE 2'

WHEN COMPANY IN ('EFG') THEN ''CASE 3' END

and take KPI as

COUNT_TABLE(CASE).

Hope this helps !

Dear Abhishek,

thank you first of all for your help. I create just a new example which will hopefully visualise my Problem more:

Lets say I have a process and the upper table shows me first of all how often a Company is connected to cases. It shows the case count per company.

Then i want a second table, that show me per case count how many different companys are connected to this specific case count.

e.g.: Case Count "10" is valid for 2 different companies (ABC and EFG).

Case Count "20" is valid for 1 company (BCD).

Case Count "30" is valid for 1 company (CDE).

Case Count "40" is valid for 2 companies (DEF and HIJ).

I know how to create the first table.

Can you help me creating the second table? Is it even possible in Celonis?

Best regards

Hi Tobias,

a little bit late maybe but you define it exactly how you described it in your last example table.

For the dimension:

PU_COUNT("Company", "CASE"."CASE_ID")

For the KPI:

COUNT("Company"."ID")

Best regards,

Florian