Forum Discussion
Mrs_Sweet
Mar 07, 2024Copper Contributor
Formula Required for Managing Stock
Good day, Could I kindly have some assistance. I have a live pivot table spreadsheet from our work server showing specific products that have been receipted for a specific month. I would like to pul...
- Mar 07, 2024
Hi Mrs_Sweet
Why not building another PivotTable, from the same Data Source (what you seem to call Live Sheet), with:
- Fields [Calendar Year] & [Calendar Month] in the Filter area
- Field [StockDescription] only in the Rows area
- SUM of [Qty Received] in the Values area
that should do what you want, no?
Mrs_Sweet
Copper Contributor
How nifty! Thank you (only recently learned Pivot tables) so I appreciate your help, really appreciated!