hello I have a table called FACTURACION_HISPAM, within that there are several columns, Mes_Consumo that has yyyy-mm format, this column tells me the date of the invoice, I have another one called Importe_USD that tells me just the amount, I have another one called Client. I need to know which client and in what month it is not billed. If I make a matrix it tells me that, but it is a huge table, I just want it to show me the clients and that months there are no invoices. If I filter by voids or 0 does not work because in reality that line in the base does not exist. So it does not show anything, the base only has a line if the client has an invoice and indicates the mes_consumo, but if a client was not billed there is no line with the date and the amount 0, it is simply not there, then I can not filter by zeros or empty because in reality that line does not exist. I read that by creating a calendar that contains all the dates of the year after I can relate it to tell me the months and the clients that do not have an invoice.
How can this be done or if there is another way, can you tell me please, thank you.
