Filter pivot tabel, show row labels

[MarleenJB]

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 per month. There are some months in which a person has no sales and other months in which he has. So

When I filter on zero sales it shows me the months in which there were no sales.

The table is group per salesperson and below all the sales persons are the months.

However, the row which shows the personsID get lost, only when I hover my mouse over the month I see the to which person it belongs.

Is there a way to remain this row label of the people and then list the months with zero sales under that person.

[#2]

I'm not sure I understand but maybe this helps.
Select any sell in the pivot table, then go to "Design" - "Report Layout" - "Repeat all label items"

If not, it would be good if you could post the file

[#3]

@MarleenJB 

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