Pierre 12/8/2021 4:16:26 PM
I did the following
I have a workspace called 'Reporting'.
In this table, you can see three tables: 'YEARS', 'QUARTERS' and 'MONTHS'.
Indexes for YEARS is the year (ex 2021), resp for QUARTERS is YEAR-TX (ex 2021-T4), resp for MONTHS is YEAR-mm (ex 2021-08)
I have many tables linked to these three tables using based on the date of the event.
In each of the reporting table I put the same informations, summarizing the relevant fields.