Highlighted

QoQ crostab data

Advisor ,
Mar 15, 2016

Copy link to clipboard

Copied

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.

Views

231

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

QoQ crostab data

Advisor ,
Mar 15, 2016

Copy link to clipboard

Copied

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.

Views

232

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Mar 15, 2016 0
LEGEND ,
Mar 16, 2016

Copy link to clipboard

Copied

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,

^_^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 16, 2016 0
jfb00 LATEST
Advisor ,
Mar 22, 2016

Copy link to clipboard

Copied

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,

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 22, 2016 0