5 Replies Latest reply on Feb 25, 2013 6:28 AM by Paul Charbonneau

# I need to have the Show Grand Totals option display the sum of my column

I'm trying to get a Grand Total of Column values to display the sum of each of the counts from each of the columns that are displayed.

From what I'm seeing on my chart, all but 1 column is doing the right thing.

The column is a Contribution to Index equation:

([% of Current total]-[% Baseline of total])*(LN([% of Current total]/[% Baseline of total]))

So when it shows the grand total, I think it is performing this equation against the grand totals for the % of Current Total and % Baseline of Total columns, which of course are both 100%, giving me a 0 value.

I need it to sum the actual values that are in the Contribution to Index column.

Any thoughts on how to do this?

Thanks,

• ###### 1. Re: I need to have the Show Grand Totals option display the sum of my column

Paul without a packaged workbook it is difficult to work out what's going on. But Zen Master Jonathan has written a 3 part series on Grand Totals, which may provide your answer.

--Shawn

• ###### 2. Re: I need to have the Show Grand Totals option display the sum of my column

Thanks Shawn, I read through the series and the only possible solution is from part 1, but I can't seem to wrap my head around what to do in the copied worksheet.  My data ends up overlapping a lot and I seem to be missing some of the steps that are shown (can't follow how he got from one point to the next).

I'm in the process of extracting a subset of the data (I'm working with over 4 million rows across about 100 columns of information and there is a lot of sensitive data that I can't share).

I'm attaching a screen shot of what it looks like.  Highlighted is the 1 value that is incorrect.  The rest of the Grand Totals are right.

Thanks again for any guidance.

Attaching the package.

• ###### 3. Re: I need to have the Show Grand Totals option display the sum of my column

Pinging Jonathan.

• ###### 4. Re: I need to have the Show Grand Totals option display the sum of my column

See the attached, it's a partial solution but should get you started. It's based on something I put together last week for this post: http://community.tableau.com/message/200656 where we use a duplicated dimension on the Level of Detail Shelf to preserve the level of detail in the Grand Total computation so the table calcs being computed inside the Grand Total can do everything the calcs did, then aggregate that. I set this up for the Contribution to Index and % Baseline of Total fields, along with a calc for the Current Month volume, you'll have to set them up for the % of Current total and Proportion Change fields.

At some point, this will definitely be a new entry in the customizing grand totals series.

Jonathan

• ###### 5. Re: I need to have the Show Grand Totals option display the sum of my column

Thanks, I'll need some time to review it to make sure I understand how you did it, but I'll let you know.

That can work for me.  I need to split my displays in to 3 panes, but it will give me the information I need and the flexibility to do the rest.

Thanks again.