10 Replies Latest reply: Sep 4, 2015 3:09 PM by Praveen Kumar Konda RSS

    Concatenated fields to be aligned one field to Left and another to right

    Praveen Kumar Konda

      Hello,

       

      Can any one help me with a function or a workaround to align 2 concatenated fields to be aligned one field to Left and another to right.

       

      For Example:

      I am concatinating 2 fields in my expression in a pivot table like [Field1] & '-', & [Field2].

      In this i wanted to align field1 to left and field2 to right.

       

      Thanks for the help in advance.

       

      Regards,

      PK