Inverse of function crosstable()

[#1]

Hi all.

I have table

Manager Month Sales

Smith Jan 10

Smith Feb 20

I want to get:

Manager Jan Feb

Smith 10 20

Is it possible?

Thanx.

[Miguel_Angel_Baeyens]

Hello,

Try this way:

Raw:LOAD * INLINE [Manager, Month, SalesA, 1, 300A, 2, 200]; GENERIC LOAD * RESIDENT Raw;

Is that what you are looking for?

[#3]

Just change the diagram type to pivot table (object properties/general) and you can move the month-dimension up as a head line.

[#4]

Miguel A. Baeyens wrote:
Hello,
Try this way:
 <blockquote>Raw: LOAD * INLINE [ Manager, Month, Sales A, 1, 300 A, 2, 200 ]; GENERIC LOAD * RESIDENT Raw;<pre>

Is that what you are looking for?

Thank you.

Its not quite what i need because generic makes many tables and i want to get only one table.

[#5]

DanielFunke wrote:
Just change the diagram type to pivot table (object properties/general) and you can move the month-dimension up as a head line. <div></div>

I need to transform table during reload not in the document. Anyway, thanx