I don't think you are using the term "running total" correctly. A running total is like a balance for a checkbook.
Have you tried just using the Analysis menu, totals, Show Grand Totals?
Yes, it only shows the total for each column, but not for each row.
I actually just want to show the Total. I've added the other column fields, Appts, Emails, Phone Calls, and Tasks just to QA.
I was able to get help and resolve this issue:
Tableau skips records that have a NULL value. I needed to create a calculated field that tells Tableau not to skip a record because it contains NULL values. To do that, I created a calculated field for each activity type:
# of Calls
IFNULL(SUM([TS5001_CData_MSD_Phone Calls].[# of Calls]),0)
# of Emails
IFNULL(sum([Number of Records]),0)
# of Appts
IFNULL((SUM([TS5001_CData_MSD_Appointments].[# of Appts])),0)
# of Tasks
IFNULL((SUM([TS5001_CData_MSD_Tasks].[# of Tasks])),0)
# of Activities
[# of Emails] + [# of Appts] + [# of Calls] + [# of Tasks]
When there is no data in particular type of activity, it will be treated as null. Hence when we add null with a numeric data it gives no result. Try to use zn function so as to convert all null to zeros.
zn(sum([emails) + zn(sum([[TS5001_CData_MSD_Appointments].[# of Appts]) + zn(sum([TS5001_CData_MSD_Phone Calls].[# of Calls])) + Zn(sum([TS5001_CData_MSD_Tasks].[# of Tasks])).
Please find attached the workbook for better explanation.
Activities.twbx 32.3 KB