Row level calculations in Matrix

Hi and many thanks for the idea.

However, this solution does not work because the report page contains a year and month filter from D_Calendar that is used to filter also other visualizations on the page. Maybe I was not clear enough when saying that the data table is connected to a calendar.

Any suggestions on how to incorporate the usage of the Date dimension?

Also, the Provider and Company are coming from their own dimension tables as mentioned in the original post. It is required to use these dimensions since the end-user wants to show the providers and companies in a specific order and these sort orders are handled by a sorting column in the dimensions.