Showing absolute and percentage values in Tableau

Question

In the form of a matrix, I want to present both absolute and percentage values in one view. In the screenshot below, I'm attempting to create a new column that displays data as percentages of the total.

The data is:

Please suggest.

Answer 1

I recreated a data like yours,

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

• 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)

• Reorder as you like

or with totals