Unable to select column in Table tool after selecting pivot radio button

Hi,

In my below workflow I wanted to use pivot in the Table tool and wanted to group the data on basis of region but I'm astonished that I'm unable to see any column here to select/to change according to my need. Is this something happening only to me, I even tried with other excel files and still unable to see any column here when selecting Pivot radio button inside Table tool. Though the other radio button "Basic" works absolutely fine. Wanted to know if I'm missing out anything

Sales_Date.yxzp

Accepted answers

RobertOdera

Hi, @george317

Please marks as an acceptable solution and like, if this works for you.

Looks like you might need some pre-steps before the Reporting Tools.

1. Summarize: Group by Employee, Group by Region, Sum Sales as Total_Sales

2. Cross Tab: Group by Employee, Column Headers = Region, Values for New Columns = Total_Sales, Method = Sum

And then, you can add the Reporting Tools (in this case, Table configured to Pivot per below)

**You can also check out the basic table examples in Alteryx (click on the basic table, then click on Open Example) to try the other pivoting styles and see which one works for you 🙂

Table Config

Solution

Workflow

Cheers!

For_george317.yxmd

All comments

RobertOdera

Hi, @george317

Please marks as an acceptable solution and like, if this works for you.

Looks like you might need some pre-steps before the Reporting Tools.

1. Summarize: Group by Employee, Group by Region, Sum Sales as Total_Sales

2. Cross Tab: Group by Employee, Column Headers = Region, Values for New Columns = Total_Sales, Method = Sum

And then, you can add the Reporting Tools (in this case, Table configured to Pivot per below)

**You can also check out the basic table examples in Alteryx (click on the basic table, then click on Open Example) to try the other pivoting styles and see which one works for you 🙂

Table Config

Solution

Workflow

Cheers!

For_george317.yxmd

george317

HI @RobertOdera ,

Thank You for the solution and it worked as you mentioned, but after completion I'm here with new doubt. After viewing the solution I'm right now thinking whether it is necessary to make Summarize and Cross tab tool before checking Pivot button in Reporting Table tool, every time. If so then what exactly is the use of this Pivot button in Table tool.

God bless for helping and taking out time for me. Thank you.

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335