CrossTab more than one Column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is brilliant. Thank you!