2 Replies Latest reply: Feb 11, 2015 8:02 AM by marc carreras RSS

    derive period from date and column heading

    Hans kleijnen

      Hi,

      I have 2 files. File 1 is actual transactions in csv. File 2 is excel converted in QV to a crosstable.

      File 1 has transaction dates dd-mm-yyyy.

      File 2 has period numbers as column headers: 01, 02,03 etc.

      when creating a pivot table in QV I get columns such as

               

      Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8
      0102janfeb
      ActualPlanActualPlanActualPlanActualPlan

       

      Where 01=jan and 02=feb

      changing headings in excel to jan, feb etc does not solve my problem

       

      who can help me to solve this issue?

       

      krgrds Hans

       

      Het bericht is bewerkt door: Hans kleijnen