2 Replies Latest reply on Jan 27, 2015 10:31 AM by Naquiyah Cash

# Grand Total on numerous metrics - Not working on some metrics

Hi Tab Gs

I have read most of the forum topics on this and blogs however most of the resolutions on grand total being incorrect and solutions are on one measure.

Below I have a table with 6 measures from which all the grand totals are fine apart from 2 and not sure how to fix this. i know its got something to do with some aggregation but no clue how to solve for it.

Metrics I need a resolution for on the Grand Total:-

Total Hours Worked - (This is Count of Dept + Name ) * Number of hours in Dec

formula - COUNTD([Dept + Name]) * SUM([Working Hours (Working hrs 2015)].[Monthly Working Hrs])

This should be 1288 not 3864

% of Time Tracked -  ([Time in Hours]) / [Total Hours Worked]

This should be approx 2%

If anyone can help me that would be great!

Thanks

Naquiyah

• ###### 1. Re: Grand Total on numerous metrics - Not working on some metrics

Hello Naquiyah Cash,

Please review this document and associated articles:  Why Your Grand Total or Subtotal Isn't Working as Expected

This will cover the whys of what is going on.

The attached workbook utilizes Table Calculations for each of the measures and a copy of the the field Owner Department for each of the fields to reference as the level to compute at.  I hope this helps out.  If you have any questions, please ask away.  The grand total issue is a fairly common question/misunderstanding of how Tableau works.

Patrick

• ###### 2. Re: Grand Total on numerous metrics - Not working on some metrics

Hi Patrick

Thanks that did work. In a real annoying way and still trying to understand it but it works.

Just a minor issue. Since I used the window formula I am unable to format the row numbers to be centered. Any reasoning behind that?

Thanks

Naquiyah