Excel Pivot (Consolidate data based on the open and closed date)

• Image one is the source data


• Image two is the required output

we have 4 date columns(created year/month. closed year/month). The tricky part in the output is the closed count.

In the output, the columns(year,Month) are based on (created year/month) so when i pivot the source data value the closed ticket count should be based on the columns(closed year/month).

Thanks In Advance