8 Replies Latest reply: Apr 20, 2017 2:38 PM by Goutham Kandukuri RSS

    Sum of specific rows in a Straight Table chart

    Goutham Kandukuri

      Hi,

      I am trying find a way to get Sum of specific rows in a Starlight table Chart.

      here is my expression in the straight table

      i cannot  use simple sum or aggr because the chart has Pick function which produces different result set for each dimension in a row.

       

      I have 7 rows. I am trying to get the totals in the last row. Some thing like sum(row(1)+row(2)+row(5)+row(7)) from column 1

      and same thing for column 2

       

      Can some one please advise.?

       

      Here is an example set

            

      Cost ElementValuePercentPercent 2Percent 3 Percent 4
      ROW 1374709.460.51540.51549.09938.2969
      ROW 2936834.911.28871.288622.749620.7437
      ROW 3521131.920.71680.716812.654911.5390
      ROW 400.00000.00000.00000.0000
      ROW 51457966.830.00000.00000.00000.0000
      ROW 6416083.050.57230.572310.10399.2130
      ROW 7270109.780.37150.37156.55925.9808
      ROW 800.00000.00000.00000.0000
      Total2518869.123.4648166853.464700461.1669289755.77349614