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: