Adding new rows to report

Hi lbendlin ,

actually I tried to append the tables Power Query, but it did not help. The report is strucuted by a Project / Invoice hierarchy. If I cannot add somehow a row to the "AInvoiceCalc" table or even "only" in the report, then what I would like to do might not be possible as you say. I might try at a later stage once again.

In relation to dyamically filter content I would to ask you the following.

Now I have a slightly changed data model:

I have created an additional table which returns one column only containig any INVOICECODE fully compensated by a creditnote. That table "FilterFullyCompensatedInv" has a relationship with the table "AInvoiceCalc". 

I would like to filter "AInvoiceCalc" in order that it does not contain any Invoices which are contained in "FilterFullyCompensatedInv" if possible only for one page of the report, for other pages "AInvoiceCalc" should not be filtered. 

Best regards