How sum 'Tablix Column Values in a textbox' in SSRS

Question

In SSRS, I've tablix that is grouped by Products,as below:

Product | Billings

ABC     | 15
ABC     | 20
XYZ     | 35

My business requirements are to get total billings in a separate textbox. I tried as below (Textbox2 is the tablix textbox for billings):

=Sum(ReportItems!Textbox2.value)

But it throws error:

The Value Expression for the textbox 'Textbox3' refers to the report item 'Textbox2'. Report Items Expression can only refer to other report items within the same grouping scope or a containing grouping scope.`

I need help on this to get it done. Thanks in Advance

Answer 1

Refering to a report item whithin a group can only be done within the same group. Your error description says it as well.

But you dont need to refer to this report item, just use the field from the dataset in the textbox again.

For the total billings, just add a textbox to your report and write the following expression:

=Sum(Fields!Billings.Value)

This will give you the overall total value (without the Product grouping).