Hi everyone!
I'm trying to figure how to create a custom total. So my situation is I have a list report with an overall total row at the bottom. Now my dilemma is I need to add a new total row where only certain rows get totaled. I still need the overall total row, and I'm not sure how to create a total row that only sums the rows I tell it to. Any advice?
Thanks!
There are a few ways, but one option would be to add an additional column to the report containing a calculation along the lines of;
If (required row) then (value) else (0)
Then you could just total that column.
Then hide the column if you don't want to see it.