Count Qty by mth to the order date

Hello,

I need a formula that helps me calculate the quantity by month to the order date and also by venue and type. I have tried to use a Pivot Table to create a job that is effective, but when I add in the entry but there is no automatic update the quantity to the summary :(

Here I enclosed the job sample as pic shown:-