I'm hoping someone can help!
I am trying to create a filter that will allow me to view comp stores and non-comp stores sales. Here, a comp store is one that has sales for all of 2017 and YTD 2018 (as of today this would be 75 weeks of data). Ideally, the filter would be dynamic, based on a max date so there is as little manual updating as possible. The filter will need to be applied to a table like this one:
I have attached a workbook showing weekly sales by store number and am using Tableau Version 10.5.
Any help would be greatly appreciated!