Two expressions in pivot table row by row

[#1]

I want to create a pivot table looking like this:

Dimensions: country, pass_fail_status

Expessions: count(id). count(id2)

Any idea how to achieve this?

I'm able to show one expression only. If I add the second expression, it becomes two tables.

I also tried using normal table, which solved the problem, but the presentation is not nice. The country names will show twice.

[Gysbert_Wassenaar · Accepted solution]

You'll have to use a trick for it for now with a synthetic dimension =ValueList('Count 1','Count 2') and one expression =If(ValueList('Count 1','Count 2')='Count 1', count(id), count(id2) )

[#3]

fantastic! thanks for the trick