Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (3.5k points)

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.

1 Answer

0 votes
by (8.7k points)

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. 

Browse Categories

...