topic Two expressions in pivot table row by row in App Development

Two expressions in pivot table row by row

Wed, 07 Dec 2016 12:43:11 GMT

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.

Re: Two expressions in pivot table row by row

Gysbert_Wassenaar — Wed, 07 Dec 2016 12:45:20 GMT

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) )

Re: Two expressions in pivot table row by row

Wed, 07 Dec 2016 12:51:23 GMT

fantastic! thanks for the trick