Hi Abhishek:

The "grand total" is the sum of the first three values. The tool tip indicates you have 4 marks selected so you are summing the first three values along with the grand total. The value in the tool tip is exactly double the grand total.

Thanks!

Hi Abhishek:

You've selected an entire column of data which includes that "grand total" mark. Because the "grand total" mark is selected, it will be included in the total in the tooltip. "Grand Total" is just a title with a calculation and Tableau doesn't see any difference between a "grand total" mark and any other mark on the screen. If you select 5 marks, it will show the tooltips for those 5 marks. I'm not sure I know of a workaround where you can select a column from the header and have it NOT include all the marks other then Control-Clicking to de-select the marks not desired.

Wish I could be more helpful - maybe someone else here will have another idea.

Thanks!

As Nathan had pointed out this is Tableau's default behavior. The only workaround I can think of would be to have a separate worksheet for the grand total, see http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-1/ for details.

Jonathan

I think it's a feature - when we select a header we select all the marks associated with the header, which includes all grand totals and subtotals.

Jonathan