Hi @Christopher Jack ,
I'm not sure if you just want to get these Total values, because during my test, I selected [Landed Cost]——Insert Row——Inside Group-Below, and then used it in the newly created row: =Sum(Fieilds !FieldName.Value) can get the total of each column.
Taking [Retail Rice] as an example, there are a total of 8 rows of data in its detail row, which are four rows of value "60" and four rows of value "100", so the expression =Sum(Fieilds!FieldName.Value)
is used when we calculating the value of eight rows.
If you want to get the total in the figure below, you can also select [Landed Cost]——Insert Row——Inside Group-Below to create a new group inside row.
Then use the following expression,please refer to the following images:
Hope this helps!
Best Regards,
Joy
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.