Hello,

For a business that is selling services with annual or monthly subscription, i need to get ONE table that contains :

1) ROWS = COMPANY NAME

2) COLUMNS = MONTH

Date range : LAST YEAR (Actual data) , but  also UPCOMING 12 MONTHS, based on recurring invoice settings.

Eg Client  that ordered on March 2023 for an annual subsription, i will expect to see that on March 2023 AND March 2024, in the same table.

How can this be done ?

For example, today that is January, i would expect the following table :