4 Replies Latest reply on Jun 24, 2016 1:52 PM by Kourtney Winans

# Grand Total Issue - Using Sum of Averages in a calculated field

I want the Grand Total aggregation to use the sum of averages within a calculated field instead of the total average, but I can't seem to get it to calculate correctly.

Below is a screenshot of the Tableau table with a few call outs. The column I'm having trouble with is "% Growth Goal Attained" - the percentages for the individual categories are calculating correctly, however the Grand Total row is not calculating the way I need it to. The 206.82% on the Grand Total row should actually be 75.18%, which is the growth of 3.14 divided by the goal of 4.17. I have done a lot of testing trying to get what I need, but nothing seems to work. On the screenshot and the attached workbook, you can see a couple of the different things I tried.

I saw the below discussion, which seemed to be very similar but when I tried to replicate it, I was not successful. Any help would be greatly appreciated!

Grand Total - Sum of Averages within a calculated field

Thank you!

Kourtney

• ###### 1. Re: Grand Total Issue - Using Sum of Averages in a calculated field

Kourtney,

I don't think I understand everything, but looks like you need to use LOD to calculate [% Growth Goal Attained]

[% Growth Goal Attained (copy 2)]

{include[Category]:[Category Growth]}/([Category Growth Goal])

Thanks,

Shin

9.0 attached.

• ###### 2. Re: Grand Total Issue - Using Sum of Averages in a calculated field

Thank you, Shin! Your help is definitely appreciated and that is exactly what I need, but unfortunately I can't use it. I still have to use Tableau v8 because the server at my company has not been updated yet. Do you know of any workaround in v8? Shinichiro Murakami

• ###### 3. Re: Grand Total Issue - Using Sum of Averages in a calculated field

I tried quite a bit, but that's not easy.

You have so many formulas to get some fields.

I may be able to achieve the request with re-structuring all the formula from the scratch, but that's not realistic...