Selecting the last value in a pivot table by week

[richiebkerry]

Hello All,

I have a pivot table by week and material detailing how much was paid for that item on that week.

I'd like to select the last price paid from the pivot, how do I do this with returning zero's if the item was purchased that week?

Thanks in advance.

Rich

 

[richiebkerry]

Hello, can anybody help with this please?