5 Replies Latest reply on Mar 31, 2016 1:00 PM by Łukasz Majewski

# Grand Totals with Table Calculations - Help Please!

Hello,

I'm trying to create a grand totals calculation for columns based on a table calculation, but I cannot get Tableau to cooperate with me.  It reverts to the sum of the original measure ignoring my table calculation.  In the attached workbook, the measure I'm trying to total is Future Sales Projections, which basically replaces null values from the Sales measure with the actual value from 12 months prior.  I've used the superstore data but in reality this is for another data set that I cannot share.

Any help is greatly appreciated.

Thanks!

Steve

• ###### 1. Re: Grand Totals with Table Calculations - Help Please!

Hi Steve,

I couldn't feel any difference on the Grand Totals as you are projecting same Sales data for future sales.

Also, formula for future year sales depicts as previous year when you say -12.

Wasn't it supposed ot be like this: YEAR([Order Date]) >= YEAR(Order Date)-1?.

Thanks,

Jothi

• ###### 2. Re: Grand Totals with Table Calculations - Help Please!

Hi Steve have you seen this workbook in the workbook library?

• ###### 3. Re: Grand Totals with Table Calculations - Help Please!

Hi Jothi,

The future sales do have differences, primarily in months where there is no value for sales (see below, the future sales number pulls from same month prior year).  And looking at the monthly totals I need to look at same month prior year, so 12 columns to the left. Granted these are small numbers but my real data has larger differences.   It's the grand total for future sales that's not working because of the table calculation I assume.

• ###### 4. Re: Grand Totals with Table Calculations - Help Please!

Hi Nicholas,

I had not, but just tried to follow the steps and it doesn't seem to work. Not sure what I'm doing wrong.

• ###### 5. Re: Grand Totals with Table Calculations - Help Please!

Is the attached fine? Totals for 2014 are slighly higher than TOTAL(SUM([Sales]))

For best explanation please refer to this awesome video: Customising Grand Totals - YouTube