
2. Re: How to add total summary of a column of data that is in rows?
Jackie Sandling Jun 9, 2016 9:39 AM (in response to Mahfooj Khan)Hi Mahfooj,
Thanks for your suggestion. I had already tried that which is why I'm posting the question. Instead of an actual total I get a grand total that shows as blank. No * or null value, just nothing. Would you know why that is or how to fix? Thanks for all your help!

3. Re: How to add total summary of a column of data that is in rows?
Mahfooj Khan Jun 9, 2016 9:56 AM (in response to Jackie Sandling)Because Tableau calculates Grand Totals only for multiple items within a measure, not across different measure values.
Tableau does not compute Subtotals and Grand Totals as just an aggregation (Sum, Avg, etc.) of the displayed marks. Instead, Subtotals and Grand Totals are computed as a separate calculation of the Measure at a coarser level of granularity. In other words, you may be expecting the total to be computed as an aggregate of an aggregate (like a total Sum of an Avg Sales per Department), and Tableau computes Subtotals and Grand Totals as the original measure at a higher level of aggregation (for example, the Avg of Sales measure computed across all Departments).
A Grand Total for columns is computed as if there there were no Dimension pills on Rows. For a SUM() measure this looks the same as a Sum of Sums, but for an AVG() measure the Grand Total is an Avg computed across every row. If you have more complex calculated fields, then it can get even more complicated. There are a variety of techniques to customize Subtotals and Grand Totals to get desired results. Follow below mentioned links
Customizing Grand Totals – Part 1  Drawing with Numbers
Customizing Grand Totals – Part 2  Drawing with Numbers
Customizing Grand Totals – Part 3  Drawing with Numbers
I hope this may help you.
Mahfooj

4. Re: How to add total summary of a column of data that is in rows?
misba.masood Feb 2, 2018 9:40 AM (in response to Jackie Sandling)Hello Jackie,
Did you find the solution for your question. Cuz I too in need of the solution.
Regards,
Misba

5. Re: How to add total summary of a column of data that is in rows?
Carol Cheng Feb 26, 2018 10:55 PM (in response to misba.masood)Hi,
I was also looking for a solution and found this. Not sure if this might be of help to you.