SUM({<[Date]={"=inweek([Date],today(1),-1)"}>}[Sales])
-
SUM({<[Date]={"=inweek([Date],today(1),-53)"}>}[Sales])
In a table, the above will show me which of my car dealerships are declining in sales from the previous week vs that same week last year if I add my Car_Dealership dimension.
How would I go about COUNT'ing those dealerships who return as having declined? Say out of the 4 dealerships that I own, 2 of them performed negatively vs the previous year's same week (53 weeks ago)?