How to use Cross Tab

[FelipeLima]

Hello everyone.

I have the following table:

COD EMISSOR    MONTH SOLD? COUNT

10389021000102 11/2017  NO         2
10389021000102 11/2017  YES       8
10389021000102 12/2017  NO         4
10389021000102 12/2017  YES       6
10389021000285 11/2017  NO         8
10389021000285 11/2017  YES        2
10389021000285 12/2017  NO         6
10389021000285 12/2017  YES       4

i am trying to use the Cross tab funciontality but without success.

I need to put it in the following way:

COD EMISSOR    MONTH  SOLD YES  SOLD NO

10389021000102 11/2017         8                   2

10389021000102 12/2017         6                   4

10389021000285 12/2017         4                   6

10389021000285 11/2017         2                   8

does anyone know hot to do it?

thanks :)

[MSalvage · Accepted solution]

@FelipeLima,

Yeah, just group by COD EMISSOR and MONTH then New column header as SOLD and Values as COUNT.

Best,

MSalvage

[phoenix64]

I do not see the "New Column Header" Cross Tab tool in Alteryx 2019.2 version. How do I add new columns?