-
1. Re: Grand total of averages
Chris Tsui Feb 1, 2013 9:14 AM (in response to Patricia Santillan)Hi Patricia,
I believe Tableau is doing what it is epxted to do in the Grand Total column which is taking the formula used and performing it at a higher level of detail.
I ran into a similar issue before and I found that Johnathan Drummey's Article on Customizing Grand Totals (http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-2/) to be extremely helpful.
From that article I believe what you'll need to to is to modify your formula to look similarily to:
IF MIN([Division]) != MAX([Division]) THEN
//Grand Total result
SUM([Ridership])
ELSE
//detail row result
sum([Ridership])/countd([DATE])
END
Because the Grand totals ignore the Division pill when aggregating, the if statement would be false when [Divisions] are present (in the details area).
It took me a while to wrap my head around it, but I think this is what you're looking for.
And I will always caveat with..... the Experts though may have a better or more correct explanation
-
2. Re: Grand total of averages
Patricia Santillan Feb 1, 2013 11:48 AM (in response to Chris Tsui)Once I figured out the reason for the difference I understand why I just needed a different solution for this instance. The article was super helpful but over my head in the explanation part. I'm having a hard time wrapping my head around it but if I simply follow the instructions blindly I can get to the point were I get multiple values - the right values I might add - on top of each other so it appears in bold. I can't get the min/max formula to work for me, either Johnathan's formula or your suggestion, but I think I'm ok with that. I probably would have bolded it anyway. I am going to have my co-worker take a look at it. She is way more skilled at this.