2 Replies Latest reply: Sep 11, 2017 9:18 AM by Andrew Walker RSS

    Cross table issue

    Saurav Gupta

      Capture.JPG

      I want to have a cross tabular view of my data. I tried using Pivot table as well, but the result was not satisfactory.
      Please see pic above. In my report in need to show -(say by row 1).

      in Sep'13 total 176 users get registered, out of which only 7 place orders in Sep'13, only 14 place orders in Oct'13, only 18 place orders in Nov'13, and so on.

      Similarly for Oct'13, total number of new users getting registered is 308. Out of these 308 users only 11 is placing orders in Oct'13, 29 are placing orders in Nov'13, 30 are placing orders in Dec'13 and so on.

      .

      I have also search online sources, but could not get anything satisfactory. Can anyone help me on this.

        • Re: Cross table issue
          kushal chawda

          Would you be able to share the sample data?

          • Re: Cross table issue
            Andrew Walker

            Hi Saurav,

            Try

             

            Data:

            CrossTable(Month, Orders, 2)

            LOAD Date(FirstMonth,'MMM-YY') as FirstMonth,

                 [Reg Users],

                 [41671],

                 [41640],

                 [41609],

                 [41579],

                 [41548],

                 [41518]

            FROM

            [Cross table issue.xlsx] //your data was entered into this excel sheet

            (ooxml, embedded labels, table is Sheet1);

             

             

            NoConcatenate

            Data1:

            Load

            FirstMonth,

            [Reg Users],

            Date(Num#(Month),'MMM-YY') as Month,

            Num(Orders) as Orders

            Resident Data;

             

             

            DROP Table Data;

             

            The this pivot table:

            FirstMonth Month Feb-14Jan-14Dec-13Nov-13Oct-13Sep-13
            Sep-13 50363418147
            Oct-13 3144302911-
            Nov-13 1009987112--
            Dec-13 145172224---
            Jan-14 312449----
            Feb-14 726-----

             

             

            Cheers

             

            Andrew