QoQ crostab data

Advisor ,
Mar 15, 2016 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

242

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
community guidelines
LEGEND ,
Mar 16, 2016 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
community guidelines
Advisor ,
Mar 22, 2016 Mar 22, 2016

Copy link to clipboard

Copied

LATEST

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
community guidelines