When I was working on a Tableau report, I had the row labels grouped instead of being repeated for every row. With this, it was difficult to read the table because users had to view each row to understand which row label applied to it.
For example, instead of seeing the row header repeated on each line, Tableau displayed a single grouped header for multiple rows. For a clear view, I needed a way to display repeated row labels for each row.
In this Tableau tutorial, I’ll explain how to show repeated row labels in Tableau using the INDEX() function and by creating a combined field calculation.
Display Repeated Row Labels for Each Row in Tableau
In Tableau, we can display repeated row labels for each row using the methods below.
- Repeat row labels in a Tableau using the INDEX() function
- Repeat row labels in a Tableau using a combined field
- Repeat row labels in a Tableau using a combined calculation
Repeat Row Labels in Tableau Using the INDEX() Function
In this method, we will create a calculated field using the INDEX() function. Now, open the Tableau worksheet and follow the steps below.
- For the text table view, I have added the Category and Sub-Category to the Rows and measures Quantity and Sales to the Columns.
Now, we will display the category label for each sub-category row using the calculated field.
- To create a calculated field, click the Analysis tab -> Create a Calculated Field.
- Enter the Label for the calculated field and enter the formula as “INDEX()“, then click OK.
- Drag the calculated INDEX() field to the Rows and place it before all dimensions. Then, to remove the index labels, click on the calculated field in Rows and uncheck Show header.
Now, we can see that Category values are repeated for each Sub-category in the table row.