Pivot Table Row Labels In the Same Line
It is a common issue for users to place multiple pivot table row labels in the same line. You may need to summarize data in multiple levels of detail while rows labels are side by side. In this post I’m going to show you how to do it.
Lets assume you have a table of data that shows the distribution of complaints for your car deliveries to your dealers. Our tables has dealer info, error code and description and occurance (table has 1000 rows).
Now we need to make a table that summarizes errors occurance by dealer. But we want both error code and error description visble in our new table. Lets see how to do it.
First make a pivot table with required fields. Arrange the fields as shown in left picture. Your initial table will look like right picture.
Now click on “Error Code” and access field settings.
First check “None” option in “Subtotals & Filters” tab to disable totals after every row. Then navigate to “Layout & Print” tab and click on “Show item in tabular form” option.
Do this procedure also for “Dealer” field and your table will look like this:
If you also want dealer names to repeat on each row, reopen “Dealer field settings and check “Repear item labels” option in “Layout & Print” tab.
This is how you arrange pivot table row labels in the same line.