Modified User transcript report that totals results
SummaryTrying to get the 4th column to add the first 3 together
I modified the User Transcript report and tweaked it in BI Publisher to give a sum for the different item types I am reporting on. But I am trying to figure out how to get the Total column to add the totals for the 3 columns in front of it (courses, enrollments and external)
Obviously I know I could output it to Excel and then in a matter of a few seconds build a formula that totals them and populate that down to all the users, but the people that are going to be running the report are not savvy in excel which is why I am trying to embed this logic in the report.