Pivot Table Function in Alteryx

[sylvia726]

Hi,

May I ask if I can build the workflow in Alteryx to get the attached pivot table results in Alteryx?

Data Set

Customer	Product	Month	Billed Local Currency	Billed USD
A	Tier 1	May-20	2,000	667
B	Tier 2	May-20	2,500	833
C	Tier 3	May-20	800	267
A	Tier 2	Jun-20	6,000	2,000
B	Tier 3	Jun-20	500	167
C	Tier 3	Jun-20	7,000	2,333
A	Tier 1	Jul-20	500	167
B	Tier 1	Jul-20	7,800	2,600
C	Tier 3	Jul-20	6,000	2,000

Pivot Table (see attached)

Many Thanks!

Regards,

Sylvia

[ArtApa · Accepted solution]

Will the attached work for you?

[DavidP · Accepted solution]

Hi @sylvia726,

Something like this? You can't have merged headers in Alteryx, unless you use the text and table tools in the Reporting tool palette.

[sylvia726]

HI David, 

Really thanks for your response. It works and looks very good to me.

Regards,

Sylvia