CrossTab more than one Column

[dineshp]

Hi,

I have two incoming inputs which is summarized to get count for one and $ value for another. Is there a way in Alteryx to crosstab two column header at once? The final output i'd want to look like is the last image i formatted in excel.

Thanks!!

[rupali_bhise]

Hey @dineshp ,

Could you please add sample data if possible.

Thanks

[jacob_kahn]

My Alteryx is currently uninstalling and updating to the new version, so I can try to respond to you with a table.

If you can first get your data to be union as follows, you can then use a single cross tab tool to summarize your data;

Identifier	Name	Value
10001	Value	100
10002	Value	200
10001	Amount	$10
10002	Amount	$20

You would then add a cross tab tool to follow and make the header names "Name" and the values "Value"

Make sure to click "Sum" in the configuration of the values.

J

[dineshp]

@rupali_bhise :

Thanks ,I have attached here.

@jacob_kahn :

I tried unioning and following that method but it didn't give me a the format i am looking for. Please check the workflow attached

[jacob_kahn]

I took a stab for you - you have to just change the headings in one of your tables to something different to keep the data separate to a certain extent 🙂 

[rupali_bhise · Accepted solution]

Hey @dineshp , 

I almost achieve this use case, also thank you so much for this type of formatting you asked.

Attaching workflow for your reference, hope it will resolve your problem statement.

Good luck

[dineshp]

This is brilliant. Thank you!