Enquiry on setting tabulation format

[johnnyycchan]

Hi all,

How can I choose the field for cross tabulation for result? The pattern has shown as in the attachment? Thanks.

Best Regards,

Johnny

[RaviP]

Hi @johnnyycchan,

The below post might help you.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-Pivot-Table-with-multiple-rows-a...

[johnnyycchan]

HI @RaviP , 

Any idea for 1x2 dimension for cross tab? Thanks.

Best Regards,

Johnny