4 Replies Latest reply on Jul 14, 2017 11:06 AM by Lee Forst

# Averages and grand totals

Consider the following charts.

The one on the right is summing up qty by region\category for each year of order date.  I have sub-totals turned on and I have row totals turned on.

The second one is the same thing, but for the totals I have changed the Totals using Totaling Using Average rather than automatic (summing).

The problem is with the "Grand Total" value.  For example, the Central region is showing a grand total of 732.  This is an average of an average.  What it should have been is 2195. I understand why it is doing what it is doing, but that's not what I'm trying to show.

So I just what I'm trying to show is a view something like the following (done in Excel for illustration purposes).

Or is there a better way to allow the users to see this?  My example workbook is attached.

• ###### 1. Re: Averages and grand totals

Lee, you'll need to do your calculations manually.  You can't rely on Tableau's auto-totalling function to get the answer you want.

It's a little tricky but that's the only way I can see to get what you want.

Is the format of the display what you want to have in the end?  Column subtotals by Region and Grand Totals for every row?

• ###### 2. Re: Averages and grand totals

I'm afraid it is.  I know this is very Excelish, but this type of table is needed in the analysis we are doing.

• ###### 3. Re: Averages and grand totals

Take a look here: displaying average and grand total

And finally on Jonathan Drummey's personal blog (which you should have bookmarked!): Customizing Grand Totals – Part 1 | Drawing with Numbers

This is not an easy question, I'm sorry to say.

• ###### 4. Re: Averages and grand totals

Thank you Michael for your input.  Talk about being taken "out of the "flow" to come up with what should be a simple thing to do.  I was hoping I had overlooked something as some of the links you referenced I found too, but they were so old I had hoped there is something better the last 1 - 5 years.  Oh well.  Time to roll up my sleeves just to compute an average....