Tableau how to bar plot grand totals of sub-categories

0
votes

Using Analysis -> Totals -> Show Column Grand Totals only display grand total by sub-category in cross-tab format as is shown below.

enter image description here

But I wish to put the grand totals into a bar plot the same as the respective regions as is shown below.

enter image description here

Could somebody teach me how to do it?

1
data-visualizationtableau-api

1 Answers

2
votes

You can create a hierarchy and use the hierarchy to achieve your objective.

  1. Create the hierarchy
  2. Put the hierarchy field in your pane
  3. Using Analysis -> Totals -> SubTotals

You will get your desired result