Hi guys,

I´m new to Tableau and still don´t have the right feeling for writing formulas. For a second calculation I Need this calculation first but I´m struggling with it.

Hope you can help me...

Database

I have a bunch of ID´s and two related values. Val2 is censored data, that´s why I´m interested in an additional Information from Val1.

Question/Calculation

I Need an Array calculation out of Val1 for each row-value of Val2. For example...

The first value of Val2 is "1" and the Count of "1" in Val1 is for example 7, and so on...

Thank you and greetings,

Jens