Creating pivot table with filters like Excel

Hi there

I haven trying to create pivot in alteryx. Can anyone guide me to do so? I have attached the excel sheet with pivots. I want to replicate the same.

Thanks

Custdetails.xlsx

Email

Transformation

Database Connection

Accepted answers

Here is the sample workflow for your case. Hope this is helpful.

Workflow Result1 Result1 Result2 Result2

Creating pivot table with filters like Excel.yxmd

All comments

patrick_mcauliffe

@Alphaprime Can you share any of the attempts you have made so far?

patrick_mcauliffe I tried some but was not successful. See attached. Thanks for your support!

Here is the sample workflow for your case. Hope this is helpful.

Workflow Result1 Result1 Result2 Result2

Creating pivot table with filters like Excel.yxmd

Thank you very much It indeed helps me a lot. Can you show me how to format the pivot output ? I need the similar table format for the out for clear and better understanding for my customers.

Hi, with regards to the solution - Does alteryx allow for the end product (in this case the end table) to be used in other workflows.

Lets say you then wanted to use the value of the total of "david" in another workflow

Quick Links

Tags

This months top contributors

Hollingsworth 335