10 Replies Latest reply: Nov 22, 2011 5:00 AM by Antony Napolean RSS

    Calculated Row on in Straight Table

      Hello All,

       

      The problem i am facing is that i have a segment column which i am using as a dimension

      the values to segment dimension is

       

      Segment

      -------------

      D0

      D1-D3

      D4-D6

      NCP

       

      Now i need to show sum of some metric for each of these segments which is not a problem

      I also need to show one more calculated row as ALL CP which is a summation of (D0,D1-D3,D4-D6)

       

      So finally it should come out to be like

       

      Segment

      -------------

      D0

      D1-D3

      D4-D6

      All CP (Sum of D0, D1-D3,D4-D6)

      NCP