8 Replies Latest reply on Feb 6, 2019 12:26 AM by Kitagawa Kaori

# How Grand Total is calculated?

Hi Team,

I am quite new to Tableau and need advice about the methodology of grand total on Tableau.

I am trying to replicate the grand total in Excel sheet.

I thought grand total is replicable with Average function however, it is not matching average values I calculated in Excel sheet.

Median is slightly close to grand total data.  Is there anyone who could explain the methodology for me?

Any assistance would be appreciated!

Thanks, Kaori

• ###### 1. Re: How Grand Total is calculated?

We need to see your workbook to investigate.

Please attach mocked up sample data twbx, and if you could attach excl as well, that's more helpful.

In general, with table calc, G.total's behavior is not straight forward.

Thanks,

Shin

1 of 1 people found this helpful
• ###### 2. Re: How Grand Total is calculated?

Please Attach a Tableau Packaged workbook so that it will be easy  to answer your question.

• ###### 3. Re: How Grand Total is calculated?

Thank you very much for your reply!
Unfortunately, I cannot attach a Tableau workbook here due to security.

I understand grand total isn't calculated in a straight way so will have a further look.

Thanks, Kaori

• ###### 4. Re: How Grand Total is calculated?

Hi,

Find the below attachment ,Try this solution if it is working then marked as correct or helpful. Thanks,

Amar D. Savale

1 of 1 people found this helpful
• ###### 5. Re: How Grand Total is calculated?

This really depends on the level at which you aggregate the value of Buy.  I am also wondering if you are filtering out NULL values or giving them zeros.

• ###### 6. Re: How Grand Total is calculated?

Hi Kitagawa,

Is your Sales Amount field coming directly from the data or is it a calculated field?  Also, how is it set to calculate (since it's a table calculation)?  If you're unsure, click on the field on your text mark, select "Edit Calculation" and then take a screenshot of that.

Best,

Paul

• ###### 7. Re: How Grand Total is calculated?

Hi Paul,

The data is directly coming from the data source, it is not aggregated in Tableau.

Also, I have checked the calculation field. Please see the image below. Kindly let me know if I attached a wrong screen shot.

Thanks, Kaori

• ###### 8. Re: How Grand Total is calculated?

Thanks Amar. Unfortunately, this solution did not work this time.
After selecting SUM or AVERAGE, the grand total isn't changed.

I gave you helpful since it was good to know the function on Analysis tab!

Thanks, Kaori