Forum Discussion
Filter pivot tabel, show row labels
Hi, I am trying for over a day now to filter my pivot table results. As soon as I filter some of the subtotal rows of my table disappear. The table consists of the amount of sales per person ...
Hello, to permanently Repeat All Item Label and ensure that you do see the name of the field instead of Row Labels:
1. Click on File tab and select Options
2. Select Data
3. Under Data options, click Edit Default Layout
4. Check the Repeat All Items Labels box
5. Select Show in Tabular Form from the Report Layout Dropdown
Click OK
See the captions attached
