Forum Discussion
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...
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?
Think my brain turned into porridge, the above resolution... of course!!!! Thank you - works perfectly. Thank you so very much x
You're welcome & Thanks for providing feedback
Just in case... Instead of having the [Calendar Year] & [Calendar Month] fields as filters on the 2 PivotTables you can insert a Timeline & connect it to 2 PivotTables (sample attached). With that your 2 Pivots always refer to the same filtered period auto.
- How nifty! Thank you (only recently learned Pivot tables) so I appreciate your help, really appreciated!
