How to add side by side rows in excel pivot table ? | |||||||||||
Hello, I am trying to add another row into pivot table, to display them next to each other, but it doesn't work. Could you please give me advice how to do it ? | |||||||||||
| |||||||||||
Hi, To display more pivot table rows side by side, you need to turn on the Classic PivotTable layout and modify Field settings. For example will be used the following table: ![]() First, you have to create a pivot table by choosing the rows, columns and values: ![]() Created pivot table should look like this: ![]() You have to right-click on pivot table and choose the PivotTable options. Then swich to Display tab and turn on Classic PivotTable layout: ![]() Now the pivot table should look like this: ![]() As a next step, you have to modify the Field settings of the rows: ![]() In subtotals section choose None: ![]() The pivot table rows should be now placed next to each other: ![]() You can also turn off the Classic PivotTable layout and the table should look like this: ![]() | |||||||||||
| |||||||||||
| |||||||||||
![]() ![]() ![]() ![]() | |||||||||||
2022 AnswerTabs | Terms | Contact us |