5 Replies Latest reply on Jul 5, 2017 11:58 PM by Shinichiro Murakami

Incorrect Grand Totals

Somok Sarkar Jul 5, 2017 8:03 AM

Dear Users,

I am facing an issue with the grand total calculation of a table.

As per my calculation the grand total for the field "Weighted MARGIN" should return 48.44% as it should be 281,000,000/5,800,000.

Can someone please check what do I need to do to get this fixed?

1. Re: Incorrect Grand Totals

Nicholas Hara Jul 5, 2017 8:10 AM (in response to Somok Sarkar)

Hi Somok,

Have you seen this article?

Customizing Grand Total to Show Different Measure Than Table | Tableau Software
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: Incorrect Grand Totals

Somok Sarkar Jul 5, 2017 8:52 AM (in response to Nicholas Hara)

Hi Nicolas,

I saw this. But couldn't figure out exactly if that helps in my case.

Regards,
Somok
Like Show 0 Likes(0)

Actions
3. Re: Incorrect Grand Totals

Shinichiro Murakami Jul 5, 2017 9:13 AM (in response to Somok Sarkar)
Somok,

Change the formula as below.

Thanks,
Shin

sample file_tableau_SM_10.3.twbx 20.7 KB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
4. Re: Incorrect Grand Totals

Somok Sarkar Jul 5, 2017 11:54 PM (in response to Shinichiro Murakami)

Hi Shin,

Hope you are doing well

Thank you. That works!!
Like Show 0 Likes(0)

Actions
5. Re: Incorrect Grand Totals

Shinichiro Murakami Jul 5, 2017 11:58 PM (in response to Somok Sarkar)

Somok,

Thank you for asking and I'm doing quite well.
I'm glad that my answer helped you.

Best regards,
Shin
Like Show 0 Likes(0)

Actions

Tableau Community