in tableau is it possible to show percentages only in total columns

Question

n Tableau, is it possible to create a percentage of a measure and only have the percentage label show up in the total or grand total column?

For example, consider this simple table:  | | September | October | Totals | +---------+-----------+---------+--------+ | Apples | 157 | 99 | 256 | +---------+-----------+---------+--------+ | Oranges | 12 | 37 | 49 | +---------+-----------+---------+--------+

What I'd love to get instead would be:  | | September | October | Totals | +---------+-----------+---------+---------------+ | Apples | 157 | 99 | 256 83.93% | +---------+-----------+---------+---------------+ | Oranges | 12 | 37 | 49 16.07% | +---------+-----------+---------+---------------+

The few problems I've seen so far are:

1. If I let Tableau calculate percentage for the table, it applies the percentage on the measure to every cell in the table.
2. If I add another measure with percentage in the marks card and add that as a text label, it also appears in every cell, but underneath the previous label instead of to the side.

Answer 1

Yes, as according to the tableau itself the dashboard is created with two different worksheets. One worksheet contains tables with numeric total only as the other one will be of grand total column. 

Get certified in this field to make your career. Enroll in Tableau Certification now.