Create a dynamic chart that has the value and % with a timeline to choose the date

I am sending boxes that contains item... I wanna create a 2 dynamic pivot charts where I can see how many boxes they received and not received (missing), so I can track. Also, I wanna create a timeline to see a stats on daily, monthly or annually...

To sum up, I want to create two Pivot charts:

1. PivotChart that has a TOTAL of all the boxes RECEIVED and MISSING with the number and % (Clustered Column or Bar)
>>> Problem is when I select ONE MONTH, it will screw up... #REF

2. PivotChart that has TOTAL of all the boxes RECEIVED and MISSING with the number and % (Clustered Column or Bar) for EACH BOX TYPE - I wanna know how many box was sent from this type
>>> Problem is when I select ONE MONTH, it will screw up... #REF

Also, I want ONE TIMELINE that connect both charts.


Can anyone please guide me? I am terrible in chart...
request.xlsx