Didn't look into your workbook yet so I apologize if this isn't what you're looking for.
Still a little fuzzy on what you need exactly. Could you maybe bold your main question or post a picture of your desired end goal?
In the meantime- you may be looking for this:
-bring grand total into view
-change how totals are calculated
You can use analytics pane:
or Analysis tab up top:
Using the analysis tab you can change how the totals are calculated. Have you checked this tab out yet?
I've bolded my main question and attached an image of what I'm trying to accomplish on the "Measure3 Over Time" sheet in Tableau. Ideally, I'd like the ability to stack multiple clients vs. overall as well.
So like this?
If so I will explain how to do it- If it needs tweaking let's work through it
Essentially, I just made a dual axis map- one with client on color, the other without on color so it sums all the clients into one line
Sample.twbx 61.0 KB
That is the view I am looking for but the values are not correct. Weighted average values for Measure3 for all months, all clients, and overall should be >100. You can see what the correct value for a client/overall for a given month would be by using the filters on the Stats sheet. All values there are correct.