Turn table - how?

[giovanneb]

Hello I have the following situation in the table below:

product	collection	line
16301	10
16301		30

By rotating the table would have to be like this:

product	collection	line
16301	10	30

How to do it?

Thanks

[jagan]

Hi,

Add Product as Dimension, and  add  Sum(Collection) and Sum(Line) as expressions.

Regards,

Jagan.

[#3]

If you are ok with having an empyty column you can do this:

Create a straight table with dimensions product, collection, and line.

create an expression like:  if(1=1,'') with the lable of the chart as '

[giovanneb]

forgot to say that this had to be treated in the data load, I'm reading an excel spreadsheet and would leave the QVD gave as presented

[swuehl · Accepted solution]

Try using a LOAD with group by clause and summing the columns:

LOAD

Sum(collection) as collection,

Sum(line) as line,

product

from Table.xls group by product;

Hope this helps,

Stefan