We have lot of cross tab charts for our clients that has some numbers including Grand Total. See Screen shot.
when user clicks on dimension, tableau sums all columns including grand total. As a results Sum shows double the amount of what it is.
How do I tell tableau to exclude the Grand Total column when user selects dimension.
At this time it isn't possible to do that. There is another thread about this, with several links regarding this and things you *can* do, and an idea that you can upvote for this. Hide Part of Tooltip With Sum of Count(Number of Records)
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...