Summarize Tool Same like PIVOT in Excel

[jonickmabini]

Hello,

Anyone can help to replicate the PIVOT below in Alteryx.

Currently i have use summarize tool but i wanted the same output as Shown in Pivot.

Thank you in advance

[FrederikE]

You could Summarize the Dates and then get them back onto your data with a union. You would end up with smth. like this:

With a table Tool, you could make this look understandable and halfway decent. 

But to be honest, that's not what Alteryx is made for. You would want to avoid building such a thing in Alteryx, it's not a reporting tool. 

[Luke_C]

Hi @jonickmabini 

There are a lot of posts about this if you search around, however I agree with @FrederikE. The better option is to set expectations with your users on what the outputs will look like. Even if it looks like the pivot table it will not be interactive like a pivot table. If it's absolutely necessary perhaps consider outputting the data to an excel template that has the pivot table pre-configured.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-pivot-table-like-Excel/td-p/6...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-a-Excel-like-Pivot-table-with...