Pivot Table - Add another 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 am new using transformation tools (cross Tab) and I am trying to create a pivot table that summarizes product code and year... I was able to get the data grouped as product, but I don't know how to split it by year. Here is what I have so far and what I want to get... anybody has some advice how to get there?
Thank you.
Solved! Go to Solution.
- Labels:
- Transformation
- 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
Hi @grromerro tick on the Year column in the "Group data by these values" section in your crosstab tools.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @grromerro
Add year as a Group By column in the Cross Tab tools. Also add year as a join field in Join 10. You'll have to play with the column layout in Union tool. BTW instead of lining up the columns manually in the union, take out the "Sum_" prefixes added in the Summarize tool. That way you'll be able to union by column name
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for all your tips. It worked perfectly!!!
