Like for Like reporting

Hi,

I'm trying to do some like for like reporting - i.e. if one of our locations wasn't open more 365 days ago, we need to exclude the location from our report. I have a locations dimension, a date dimension, and a like for like dimension. Sitting between them is a mapping table of locations, dates and a like for like ID

 

 

I've created a report using this structure, and at location level it works as expected. As an example, Ford Newcastle became a like for like location in February 2025, so was blank in January.

 

And I'm achieving this by having a filter where the count of like for like locations in the mapping table is greater than 1

 

However this does not persist across different levels of the hierarchy. I'd expect to work from the base level of location upwards and aggregate the franchise and division accordingly but we're just seeing the totals being calculated, irrespective of the like for like / non-like for like flag

 

Has anybody done any like for like reporting and how have you achieved it? Any help would be greatly appreciated

Cheers

Rob