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,