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:

Month	Customer	Value
Jan	Jimmy	10
Feb	Jimmy	20
Mar	Jimmy	30
Apr	Jimmy	40
Jan	Jack	10
Mar	Jack	20
Apr	Jack	30

<colgroup><col><col><col></colgroup><tbody>
</tbody>

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