Using a QV pivot chart object as datasource in another QV

[#1]

Is it possible to create a Pivit Chart in one qvw and use as a datasource in another qvw?

I have a qvd list of data and I need to transform the structure.

Currently the structure of the list of data is period, statcode,amount. I need the new datasource to be period as a row, statcode as a column and amount being the value for every column.

Thanks

Glen

[johnw]

Not possible. You could always export to Excel, and read in the Excel, but that's the wrong way to solve it. You should transform the structure in script, not in a chart. What you are describing sounds like a "generic load". Something like this:

GENERIC LOAD
period
,statcode
,amount
...

Assuming I got my syntax right, that should convert the statcodes to field names, with the values currently specified in the amount field.