Pivot Table - Add another Column

Question

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.

Doc2.docx

TestingTGE.yxmd

MilindG · Accepted Answer

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

JosephSerpis · Accepted Answer

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

danilang · Accepted Answer

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 Answer

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