How to track stock movement on a monthly basis through Pivot table

**rachelexcel1** · 08-28-2019, 09:13 AM

Hi there,

I'm Rachel, I'm trying to track my stocks on a monthly basis. Below is an example of my situation and the question that I hope will get solved. Many thanks in advance!

Screenshot 2019-08-28 at 8.55.59 PM.png

**Pepe Le Mokko** · 08-28-2019, 09:35 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**rachelexcel1** · 08-28-2019, 11:05 PM

Hi there,

Thank you for your reply, I've taken your advise and have uploaded a excel sheet as attached. Do let me know if you're able to solve my issue through pivot table or using some formula. Thank you