6 Replies Latest reply: Oct 16, 2017 10:16 AM by Michael Kubbutat RSS

    Generate new Dimension from different columns

    Michael Kubbutat

      Good morning,

       

      I am stucked with the following task:

      In a table I have 5 columns:

      a) Project ID

      b) Invoice Date 1

      c) Invoice Value 1

      d) Invoice Date 2

      e) Invoice Value 2

       

      I would like get a bar chart, depicting

      dimension: all invoice dates from columns b and d

      formula: all invoice values from colomns c and e

       

      I thought to generate two new columns "Invoice Date All" and "Invoice Value All" while loading the table.

      Any idea how to put this in the script?

       

      Any help is highly appreciated.

       

      Michael