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!!
Solved! Go to Solution.
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
Thanks ,I have attached here.
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
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
This is brilliant. Thank you!