3 Replies Latest reply on Jun 15, 2018 6:39 AM by Ken Flerlage

    Pivot CHANGING field names

    Jan Paulsen

      Hello Community,

       

      I have sales data with the following structure:

       

      Region          Jan 2018    Feb 2018    Mar 2018    ...

      Europe          12                22                1

      Asia                9                8                  88

       

      I want to pivot this data so that it looks like this:

       

      Region    Date

      Europe    Jan 2018

      Europe    Feb 2018

      ...

       

      The challenge: each month a new time period is added (e.g. Jan 2019 in Jan 2019). Therefore, the methods depicted under Pivot Data from Columns to Rows will not work. Perhaps a custom SQL script anticipating future values (select "Jan 2019" as Date) would work? Is there an easier way?

       

      Kind regards,

       

      Jan