7 Replies Latest reply: Apr 14, 2014 9:45 AM by Dariusz Mielczarek RSS

    Table with multiple expression and two columns of data

      Hi community,

       

      I am calculating two columns of data 5 different business areas. However, every single value displayed in both columns is the result of a unique calculation, as the data is drawn from various external tables.

       

      Obviously i can display all the expressions in one column easily enough, but how can I designate certain expressions to appear in column A and others in column B when there are no directly common fields in the underlying data.

       

       

      Categoryrevenue (column A)
      % (column B)
      A£1,232,2325.31
      B£676,3436.47
      C£52,3563.19
      D£8,632,7547.27
      E£6,7546.61