4 Replies Latest reply: Jun 25, 2013 10:38 AM by sarah_mader RSS

    Create Crosstable with resident table

      Hallo,

       

      is it possible to create a crosstable using a resident table?

      Little example:

       

      This format :

      SerialDate
      S111-05-2013
      S203-05-2013
      S107-02-2013
      S111-05-2013
      S310-05-2013
      S209-05-2013
      S301-05-2013

       

      to this one:

       

      Serial
      01-05-2013

      02-05-2013

      03-05-2013

      04-05-2013


      05-05-2013


      06-05-2013


      07-05-2013


      08-05-2013


      09-05-2013


      10-05-2013


      11-05-2013


      S1





      1


      2
      S2

      1




      1

      S31







      1

      ?

       

      You didn't have to explain it, if there is an other post wich does so...

      But i cant find anything about and would also be happy if u give me the link to this post:)

       

      And there is no use in defining every column, because in the end the time interval will be over several years.

      And i dont want to define more than 365 days^^

      Thx

      Sarah