14 Replies Latest reply: Oct 14, 2011 8:08 PM by Luis Laura RSS

    Adding a value based on RowNo

    Torbjörn Ungvall

      Hi,

       

      I have a pivot table:

       

      2011-10-13_17-47-57.jpg

      The expression for column 1 is:

       

      If(RR2_RowNo=30, Sum(RR_Belopp), Sum(RR_Verksamhetsmål))/1000

       

      But now the customer wants to add the value from column 1, RR2_RowNo 30 (-49 937) to RR2_RowNo10 (270 771+49 937).

       

      Is that possible?

       

      I've tried with:

       

      If(RR2_RowNo=30, Sum(RR_Belopp), If(RR2_RowNo=10, (Sum(RR_Verksamhetsmål)+Sum({$<RR1_RowNo={30}>} RR_Belopp)), RR_Verksamhetsmål))/1000


      But that din't help...

       

      Some ideas?

       

       

      @Ungvall

      Senior Business Discovery Manager at Advectas AB