how to add grand total for discrete fields (columns)?

0 votes
how to add grand total for discrete columns? Is it possible or not?
Oct 21, 2019 in Tableau by ch
• 3,380 points
1,134 views

1 answer to this question.

0 votes

Hey,

You cannot add Grand Total for discrete columns.

When you try to turn on Column Grand Totals when there is a discrete measure on the Rows shelf, then the grand total for discrete measures will be blank. 
OR 
When you try to turn on Row Grand Totals when there is a discrete measure on the Rows shelf, then the following error occurs: 
Cannot turn on Grand Totals for discrete measures.

Source: https://kb.tableau.com/articles/issue/error-cannot-turn-on-grand-totals-for-discrete-measures

answered Oct 21, 2019 by anonymous
• 32,460 points

Related Questions In Tableau

0 votes
1 answer

How to create a bar graph for two fields with same value?

I believe you want to have something ...READ MORE

answered May 28, 2018 in Tableau by Atul
• 10,240 points
97 views
+1 vote
1 answer

How to add grand totals of the bar in Stacked Bar in Tableau

Hi Grim, As you have used reference line ...READ MORE

answered Sep 24, 2018 in Tableau by Machdata
• 340 points
1,911 views
0 votes
1 answer

Want to hide the Bar for Grand Total in the bar chart in Tableau

Tableau treats the whole visualization uniformly.  If you ...READ MORE

answered Aug 10, 2018 in Tableau by AwesomeSauce
• 860 points
1,262 views
0 votes
1 answer

How to use tableau to searh for text within entire data

You can use a pivot table in ...READ MORE

answered Apr 4, 2018 in Tableau by xyz
• 1,550 points
132 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
4,321 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
288 views
+2 votes
1 answer
0 votes
1 answer

How to add custom labels to bar chart and grand total charts?

Hi, Once you created the bar chart ...READ MORE

answered Mar 4, 2019 in Tableau by Cherukuri
• 32,460 points
441 views
0 votes
1 answer

How to Add a Grand Average bar to an existing bar chart.

Hi Anitha, Its easy and simple, follow below steps: 1. ...READ MORE

answered Apr 4, 2019 in Tableau by Cherukuri
• 32,460 points
113 views