Creating a 'report' from data from a SQL db which shows a count of data collected on a weekly basis. The week starts on a Wednesday.

I have a sql table with a date field.

it shows Lab Code (MINA / Intertek), sample ID, Lab_report_date

I want to show this data as a table or export such as:

The week is not calculated as a standard 'week', but from Wed - tuesday.

I've been playing around with DateTimeCalculator & Attribute Pivoter without much luck.

Is this even possible?

thanks