2 Replies Latest reply on Mar 22, 2016 3:31 AM by jfb00

    QoQ crostab data

    jfb00 Level 3

      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.

        • 1. Re: QoQ crostab data
          WolfShade Level 4

          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.





          • 2. Re: QoQ crostab data
            jfb00 Level 3

            Thanks for your reply and help.

            I am trying to crosstab the data from QoQ.

            Ok, I will wait for you idea of QoQoQ.