Set pivot to filter only values, not fields.

[FDemolin]

Hi everyone,

I'm struggling with a pivot issue.
Let's say that I have a pivot with months in the rows, customers in the columns and amount sold in the values.
Let's also say that I have a customer Jimmy who has bought every single month, and another customer called Jack that has not bought in February.
Then, when I insert a slider in this pivot and select for Jack, the pivot table wont show February, but I would like the pivot to keep showing February with 0 value.
Is that possible?

This is a source example:

[TABLE="width: 287"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Month[/TD]
[TD]Customer[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]Jimmy[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Feb[/TD]
[TD]Jimmy[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD]Jimmy[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD]Jimmy[/TD]
[TD]40[/TD]
[/TR]
[TR]
[TD]Jan[/TD]
[TD]Jack[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Mar[/TD]
[TD]Jack[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Apr[/TD]
[TD]Jack[/TD]
[TD]30[/TD]
[/TR]
</tbody>[/TABLE]


Thanks in advance!

 

[fhqwgads]

go to pivot table options, display, and tick the box next to "Show items with no data on rows" is ticked, then click ok