QoQ crostab data

[jfb00]

Hi All, still working on QoQ.

How can I pivot or unpivot the data from a QoQ? I know I can do this before the QoQ, but I have a complex collection of data and I want to use the QoQ result.

I am thinking on looping thru the query and create a new query.

Does anyone know any generic function? Any ideas?

Thanks in advanced.

[WolfShade]

Not sure what you mean by "pivot or unpivot" the QoQ data.

As far as creating a new query, you shouldn't have to loop through your QoQ to create a new query.  You could, I suppose, use a QoQoQ?

Dangit.. I used to know of a way to append a query to another query without looping, but I'm not finding the support documentation for it.  If I find it, I'll post it here.

V/r,

^_^

[jfb00]

Thanks for your reply and help.

I am trying to crosstab the data from QoQ.

Ok, I will wait for you idea of QoQoQ.

Best,