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:  | |||||||||||
| |||||||||||
|
| |||||||||||
    | |||||||||||
| 2021 AnswerTabs | Terms | Contact us |
