CODEWITHSUNDEEP
tableau-api
joy_1379
joy_1379

Reputation: 499

Showing absolute and percentage values in Tableau

I want to show both absolute and percentage value in a single view in the form of a matrix. In the below view I am trying to add one more column showing values as percentages of total

Got hint here but not able to replicate:Tableau - Both count and Percentage in Measure Values

enter image description here

The data is like this

enter image description here

can any one please suggest!

Upvotes: 1

Views: 2229

Answers (1)

AnilGoyal
AnilGoyal

Reputation: 26238

Not that difficult. I recreated a data like yours,

enter image description here

Follow these steps

  • Add slide on rows
  • Add number of records in text on marks card
  • Add table calculation on this field -> percent of total. The view will look like this

enter image description here

  • Notice a small triangle in 'no of records' field. That indicates that it is table calculation

  • Add number of records field once again to text. (Tip: Double click the field number of records to add it to view directly)

enter image description here

  • Reorder as you like

enter image description here

or with totals

enter image description here

Upvotes: 1

Related Questions