Currently, it is not possible to move the grand total to the left side of the viz. The best workaround would be to get the grand total by itself and place it on a dashboard with the details worksheet on a dashboard.
If you are using Tableau Server, a url action may be able to be used to launch a different viz. Hope this helps!
Tracy, sorry if this is inappropriate, but I love you. Thank you for your help.
When you say "if you are using tableau server" I'm not sure. I am using tableau, our company uses tableau server to publish onto our intranet portal. Does this count? i will look into it though. Thank you
with some custom SQL that duplicates the data, you can get the result you are looking as in the attached.
if you need help applying this method to your situation, please provide a sample workbook that represents your situation.