CODEWITHSUNDEEP
formattingpercentagetableau-api
dcgibbons
dcgibbons

Reputation: 376

In Tableau, is it possible to show percentages only in total columns?

In 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.

Upvotes: 1

Views: 10539

Answers (1)

dcgibbons
dcgibbons

Reputation: 376

I spoke with Tableau, and they recommended that a dashboard is created with two different worksheets. One worksheet would have the table with the numeric totals only, and the other worksheet would just be the grand total column. It's effective and seems to work well.

Upvotes: 2

Related Questions