Piviot Table Creation similar to Excel Piviot table

Question

I have Piviot table created in Excel by using total 7 fields out of 7fields one is numeric and remaining all are strings and in Excel Piviot table the configuration is, I have added one string column in FILTERS, 1 string column in COLUMNS, 4 string columns in ROWS and one numeric column in VALUES.

Now i want to replicate same thing by using Alteryx. Can anyone pls suggest the idea.

Unfortunately i can't post any data here because of security reasons.

Jonathan-Sherman · Answer

Hi @VijayAnaparthi,

Could you create a quick set of mock data with what you start with and where you want to end up at? Would make it a little easier to help you solve the issue! 🙂

Kind regards,

Jonathan