Forum Discussion
Matrix
Hello everyone, they ask me for a complicated report but I have not managed to put it together I detail the requested report. 1. Sellers 2. Sales data per week between the years 2021 and 2022 3. ...
Create a YearWeek column and then create groups based on your requirements.
Or use a SWITCH statement to define the aggregation level for each Year and week.
Please provide sanitized sample data that fully covers your issue.