Forum Discussion
Problems with multiple text fields in a Pivot Table
Hi Sari,
1) Add as rows
2) Adding the field right click and uncheck Subtotals
3) When right click on previous field and in Field settings change it on to show in tabular form
The Pivot Table will be like this
Or more faster (if for all fields) right click with PivotTable on PivotTable properties and select Classic table
Uncheck Show expand/collapse buttons here if you don't need them and uncheck Sutotals then
Hi Sari,
1) Add as rows
2) Adding the field right click and uncheck Subtotals
3) When right click on previous field and in Field settings change it on to show in tabular form
The Pivot Table will be like this
Or more faster (if for all fields) right click with PivotTable on PivotTable properties and select Classic table
Uncheck Show expand/collapse buttons here if you don't need them and uncheck Sutotals then