5 Replies Latest reply: Jun 9, 2016 2:42 PM by Hans kleijnen RSS

    crosstable heading month to period

    Hans kleijnen

      Hi,

      please see attached files

       

      I have a cross table:

        

      Rubriek2_NameYear010203040506070809101112
      Revenues2015-10.000-15.000-20.000-25.000-30.000-35.000-40.000-45.000-50.000-55.000-60.000-65.000
      Revenues2016-70.000-80.000-90.000-100.000-110.000-120.000-130.000-140.000-150.000-160.000-170.000-180.000

       

      and a regular table

        

      Rubriek2_NameDateRealised Amount
      Revenues1-1-2015-5000
      Revenues1-2-2015-12000
      Revenues1-3-2015-8000
      Revenues1-4-2015-15000
      Revenues1-5-2015-16500
      Revenues1-6-2015-19100
      Revenues1-7-2015-21700
      Revenues1-8-2015-24300
      Revenues1-9-2015-26900
      Revenues1-10-2015-29500

       

      the needed output is:

       

      PeriodPlanActual
      2015-01-10.000-5000
      2015-02-15.000-12000
      2015-03-20.000-8000
      2015-04-25.000-15000

       

      Period is setup as Year(Date)&'-'&Month(Date) as Period

       

      How to convert the period numbers in the cross table to Period?