Pivot Table - Add another Column

[grromerro]

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. 

[MilindG · Accepted solution]

In your crosstab tool, if you select year, that should get you the result.

[JosephSerpis · Accepted solution]

Hi @grromerro tick on the Year column in the "Group data by these values" section in your crosstab tools.

[danilang · Accepted solution]

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

[grromerro · Accepted solution]

Thank you for all your tips. It worked perfectly!!!