pivot recipe

debanasser1

i want to create column in pivot recipe with specific sorting ,any idea how to do it

example:

col1	col2
national	fail
international	success
national	success
international	fail

pivot

national_success,national_fail,international_success,international_fail

so pivot table column col1 ,col2 sorted desc

Catalina

Hi @debanasser1
,

The pivot recipe needs more than 2 columns. Can you give an example of the output that you are looking for?

debanasser1

i want to create column in pivot recipe with specific sorting ,any idea how to do it

example:

a	b	col1	col2
1	23	national	fail
1	34	international	success
2	44	national	success
2	44	international	fail

pivot

national_success,national_fail,international_success,international_fail

so pivot table column col1 ,(col2 sorted desc )

row identifier : a

values: sum of b