QoQ crostab data

Question

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 · Answer

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,

^_^

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded