4 Replies Latest reply: Jan 25, 2018 5:58 AM by Arpit Kharkia RSS

    Concatenate dimesion with expression in pivot

    Arpit Kharkia

      Hi All,

       

      I am trying to concatenate a dimension and expression and create a new calculated dimension. Consider the following example

       

      i have MonthYear dimension and Sales dimension. I am trynig:

       

      =MonthYear&'-'&sum(sales)

       

      which would give me,

       

      Jan-18-500

      Feb-18-200

      and so on.

       

      Can someone help me with this?