Reference Line Using LODs

Hi

I want to have a bar chart with values from a previous selling period as a reference line. Ideally, it should ignore the 'Selling period' filter which will be set to only select the latest selling period if possible. I want to use LODs as want to use these values in a treemap and colour based on higher/lower values

Sample workbook attached

Thanks

Mark