If I understood it correctly you need to show the measure value week on week rather then date on date. If thats is correct, this is what you need to do
[Week]=Week([Date Object])
Create a crosstab with [Class ID] and [Week]. The output will look something like the below screenshot.
Let us know if you are expecting something different.
Add a comment