How to add side by side rows in excel pivot table ?
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 ?
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:
|Is CSV excel file Comma or Semicolon separated / delimited ?|
|How to calculate percentage changes / growth in Excel ?|
|IF multiple conditions - combined with AND and OR in Excel|
|Incorrect integer value '' for column 'user_id' at row 1 - error|
|How to count excel cells that contain specific part of text ?|