Grand total portal rows
I'm sure this has been asked 100 times before and I've been searching around, each time finding only half an answer...
What I have is a portal showing projects and how long each stage of a project will take, ie stage 1 = 1 hour, stage 2 = 3 hours, stage 3 = 23 hours.
I've added these up in my main table using a calculation to give me 9 hours on this project. So far so good because all this sits on one row of a portal against one project ID.
When the customer has several other projects, I want to add up all the time against all the projects, ie, the row totals, to create a grand portal summary.
That's where it goes pear shaped.
In the picture I've attached each row is a project and what I want to get in the grey area is a total showing '59 hours'
Hope that makes sense.