richiebkerry
Board Regular
- Joined
- May 4, 2016
- Messages
- 54
- Office Version
- 365
- Platform
- Windows
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
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