Pivot table date filter linked to a cell

[SPhilly1023]

I would like to build a pivot table that returns all items on or before the date contained in cell D2. Does anyone know if it is possible to do this and if so how? Thanks

 

[jorismoerings]

Hi and Welcome to MrExcel,

This is the Link to answer on same type of question asked and aswered before on this forum.