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 ?
0
give a positive ratinggive a negative rating
26 May 2019 at 07:29 PM
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:

pivot table

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:

field settings

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

0
give a positive ratinggive a negative rating
29 May 2019 at 06:50 PM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
Follow us on Facebook
2022 AnswerTabsTermsContact us