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

    Adding a value based on RowNo



      I have a pivot table:



      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?




      Senior Business Discovery Manager at Advectas AB