Manipulating large data sets in an Inventory management scenario

Hello.

I am an Inventory Lead and I can utilize the basics, and have googled this question and cannot figure out the best way to approach it. It may be way of thinking more than my application of my skills.

Scenario:

I have a large data set of adjustments made for a given time frame.

Goal: to not manually count the number of adjustments per item (we have over 2k). And also manipulate that data to see: how much, locations, reasons. This data would then be used to focus in on certain areas to improve inventory accuracy.

Is this an application of pivot tables that I am misunderstanding? ​I tried some videos and I couldn't seem to make it work.

Im sure this is an easy answer. I just can't piece it together.

Thank you all