Cross Tab output for more than one column Sales and Qty for each product

[SanjayM]

I need the output shown as below. How can I get it in EG

Product Code Year 2005 Year 2006
Total Sales Total Qty Total Sales Total Qty
Code1 1000 900 3500 2500
Code2 2000 800 4000 1500

Total

I have a daily Sales transaction table storing the sales and qty figure for

I can get a data set of yearly values of Sales and Qty per product.
Can I use transpose to get the above out put

We have tried with one transpose column and it works. Here there are tqo columns to be transposed, Sales and Qty.

Which columns should be grouped and transposed.
What are
New Column names
New column labels and
Copy variables

[deleted_user]

I thought I saw the same question posted somewhere else, and a response from Cynthia demonstrating the use of the Tabulate procedure.

You should look up the answer she gave, searching on the key words Tabulate and Class.

Since you say "Output", I presume you mean a report and her answer dealt specifically with rows defined by a classification variable, and summary variables reported under a classification variable.

In her final answer she also indicated where in EG you can find the Summary tables builder to build the table code.

Kind regards'

David