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.
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.
Thanks for your reply and help.
I am trying to crosstab the data from QoQ.
Ok, I will wait for you idea of QoQoQ.