-
1. Re: Tableau is showing double of it sales
Nathan Panuco Nov 10, 2016 12:33 PM (in response to Abhishek Yadav)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!
-
2. Re: Tableau is showing double of it sales
Abhishek Yadav Nov 11, 2016 2:15 AM (in response to Nathan Panuco)Hello Nathan,
Thanks for quick response. Yes it is adding the total as well with rest of the data. But is there any way we can prevent tableau to add grand total along with rest of the data in tooltip.
Regards,
Abhishek
-
3. Re: Tableau is showing double of it sales
Nathan Panuco Nov 11, 2016 6:39 AM (in response to Abhishek Yadav)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!
-
4. Re: Tableau is showing double of it sales
Abhishek Yadav Nov 11, 2016 10:18 AM (in response to Nathan Panuco)Thanks for the explanation Nathan. It does really cleared my doubt. Thanks a lot for this.
-
5. Re: Tableau is showing double of it sales
Jonathan DrummeyNov 12, 2016 8:22 AM (in response to Abhishek Yadav)
1 of 1 people found this helpfulAs 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
-
6. Re: Tableau is showing double of it sales
Abhishek Yadav Nov 12, 2016 11:15 AM (in response to Jonathan Drummey)Hello Jonathan,
Thanks a lot for your response, just wondering is it a flaw or a feature.
Regards,
Abhishek
-
7. Re: Tableau is showing double of it sales
Jonathan DrummeyNov 12, 2016 1:03 PM (in response to Abhishek Yadav)
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