This functionality is not currently possible, a great one for the Ideas section though!!
The best way around this is to find the desired grand total on a separate sheet and place the two worksheets on a dashboard together. Hope this helps a bit!
You might have to create a calculated dimension (field) on what you want to max by, then a calculated measure (field) based on that and then maximize (agg) on this new measure inside the view. Then you might be able to control some of this default behavior.
I was having the same issue w/ aggrregating on calculated fields - not sure if this solution would work for you but maybe it would...
I see that you frequently post "This functionality is not currently possible" when table calculations can accomplish what is being requested.
I would love to have a conversation with you to show you that many of these things that you think are not possible are in fact very doable, and many times with multiple routes to achieve the desired results.
I know you are trying to help, and I would like to help you in return.
Joe, that is exactly what I was looking for. I figured a calculated field is what I needed, but I am not very good at those yet. Thanks.
I read this and appreciate the example as I'm trying to do something similar and have been having no luck.
I have a list of names that were paid on certain dates w/ multiple lines per date an in the column I'm looking at in this example those are duplicate values.. I want to sum only the max for all the lines on a given date - but I want to sum the max of each employee on each date without having to display all employees. Correct me if I'm wrong - but the calculation you have shown in this example doesn't work because it is based on a table calculation.. right?
Any insight or ideas you have would be awesome. I posted my original question in another thread before I noticed this one.. http://community.tableau.com/thread/124885