Calculate totals

[CSmith]

I am trying to calculate and display the totals for the 'Not Sold' and 'Sales' columns the same as the 'Total Vol' column in the Total column at the bottom of the report.

[MayilVahanan]

HI @CSmith 

Can you try with this option in expression tab.

[CSmith]

I am unable reply in the community. But that total mode option is greyed out for me because I am using a pivot table not a straight table. Is there a way to put some code in the expression that will allow the calculation using a pivot table?
Thank you

[MayilVahanan · Accepted solution]

HI @CSmith 

For Pivot table, Try like below 

=If(IsNull(RowNo()) or Rowno()=0 , urtotalexpression, uroriginalexpression)

[CSmith]

Thank you!!!!! That worked perfectly!!!!!