3 Replies Latest reply: Feb 17, 2012 8:16 AM by obed.adames RSS

    Date Column Help

      Hi

      I have the following Data Example, but I can’t find a way to group the date so it can be manage in QV, because it's separete ..

       

       

      NameService Name01/01/1202/01/1203/01/1204/01/1205/01/1206/01/1207/01/1208/01/1209/01/1210/01/1211/01/1212/01/12TOTAL 2012
      companyService         1,073         1,073         1,073         1,073         1,073         1,073         1,073         1,073         3,889         2,816         3,119         3,119      21,527
      Company 2Service 2        7,271         7,271         7,271         7,271         7,271         7,271         7,271         7,271            908            908            943            943      61,866
      Company 3Services 3







              1,940         1,940         2,425         2,425         8,730

       

       

      if you can see all Month are in different column, I want to know if there’sa way to group or work with this.

      let me know if need more info ..

      Thanks

        • Date Column Help

          try with CrossTable(). For example:

           

          Directory;

          CrossTable(Month, Amount, 2)

          LOAD Name,

               [Service Name],

               [01/01/2012],

               [02/01/2012],

               [03/01/2012],

               [04/01/2012],

               [05/01/2012],

               [06/01/2012],

               [07/01/2012],

               [08/01/2012],

               [09/01/2012],

               [10/01/2012],

               [11/01/2012],

               [12/01/2012],

               [TOTAL 2012]

          FROM

          Book1.xlsx

          (ooxml, embedded labels, table is Sheet2);

          • Date Column Help

            Hi,

            I have the next situations and it is that the data I received have combined the year 2011 and 2012 in one file for example: 

            Is similar to the data above but adding the columns of year 2011 for example, I try to use the Cross table but it group all columns, I tryto not include those columns but when I try use the cross table it add all the column,

            I want to know if there’s a way to do a cross table for those columns separately or another way to work with this thanks.

            I will appreciate your help