How can I extract a report by customer by month with column for total open and total closed?

 

Something like:

 

Customer | Year-Mo | Total Open | Total Closed |

Custom X | 2018-12 | 999999        | 999999         |

Custom X | 2019-01 | 999999        | 999999         |

Total Customer X       | 9999999     | 999999         |

Custom Y | 2018-12 | 999999        | 999999         |

Custom Y | 2019-01 | 999999        | 999999         |

Total Customer Y       | 9999999     | 999999         |

 

 

Thanks in advance,

 

Edson Richter

 

 

 

Soli Deo Gloria.