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