1 Reply Latest reply: Jun 6, 2013 1:21 PM by 997624 RSS

    How to have several columns under one title..

      hello experts,
      Im sure the title of my question is a confusing, but basically I have three columns; all from different subject areas. One is Product name, title name, and Tender name: My boss wants to have a union report and all these items to be under one column titled "description")...
      Does anyone have an idea over how to do this??? Somehow, my understanding is for unions to work the columns have to match or have a dummy column for one we need from another subject area.

      If not possible, can one "Concatenate" from two separate areas?.. like this: +("Calendar Dates"."Date Calendar Month Abbreviation"||' '||CAST("Calendar Dates"."Date Calendar Year Number" AS CHAR))+

      I am confused, please help

      Edited by: 994621 on Jun 6, 2013 10:47 AM