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 ?

posted on 26.05.2019 at 19:29

Carly

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:

excel table

First, you have to create a pivot table by choosing the rows, columns and values:

pivot table fields

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:

pivot table options

Now the pivot table should look like this:

classic pivot table

As a next step, you have to modify the Field settings of the rows:

In subtotals section choose None:

field settings

The pivot table rows should be now placed next to each other:

pivot table rows next to each other

You can also turn off the Classic PivotTable layout and the table should look like this:

pivot table rows side by side

posted on 29.05.2019 at 18:50

Tim