Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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?
@Ungvall
Senior Business Discovery Manager at Advectas AB
Hi,
This is my offer, pls to see image attached
Good luck, Luis
Hi,
Thanks - but the result should be:
RowNo 10 424 221
RowNo 20 -38 822
RowNo 30 -18 065
Based on your pict.
@Ungvall
Senior Business Discovery Manager at Advectas AB
Basically we are doing such things on the data level by joining a table with the aggregation logic.
- Ralf
Hi,
May be you miss to total your sum
If(RR2_RowNo=30,
Sum(RR_Belopp) ,
If(RR2_RowNo=10,
Sum(RR_Verksamhetsmål)+Sum({<RR2_RowNo={30}>} total RR_Belopp),
Sum(RR_Verksamhetsmål)
)
)/1000
Regards
Sven
Hi,
This is my offer, pls to see image attached
Good luck, Luis