Pivot Table Function in Alteryx

Question

Hi,

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

Data Set

CustomerProductMonthBilled Local CurrencyBilled USDATier 1May-20                                   2,000             667BTier 2May-20                                    2,500             833CTier 3May-20                                       800             267ATier 2Jun-20                                   6,000        2,000BTier 3Jun-20                                       500              167CTier 3Jun-20                                   7,000         2,333ATier 1Jul-20                                       500              167BTier 1Jul-20                                   7,800         2,600CTier 3Jul-20                                   6,000        2,000

Pivot Table (see attached)

Many Thanks!

Regards,

Sylvia

sample.xlsx

ArtApa · Accepted Answer

Will the attached work for you?

DavidP · Accepted Answer

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.