How to get specific cell value in SSRS grouping?

Question

I am making an SSRS report using SQL Server Report Builder. I have column and row grouping as follows :

I want to pick up the row that is highlighted in the red box below. How do I access that specific cell and display its value in some other table in the report? As you can see the value that I want to access is a column grouping total.

RET RET · Accepted Answer · 2018-04-20T12:20:44

Use custom code:

Function SumLookup(ByVal items As Object()) As Decimal 
If items Is Nothing Then 
Return Nothing
End If 
Dim suma As Decimal = New Decimal() 
Dim ct as Integer = New Integer() 
suma = 0 
For Each item As Object In items 
suma += Convert.ToDecimal(item) 
Next 
return suma 
End Function

Then in the cell where you want to reference the value:

=Code.Sumlookup(lookupset("2073/074",Fields!FiscalYear.Value,Fields!Value.Value,"DataSet"))
*
lookup("2073/074",Fields!FiscalYear.Value,Fields!Alfa.Value,"DataSet"))

How to get specific cell value in SSRS grouping?

2 Answers