In Retail Domain, we have a status for each store like 'New', 'Trading', 'LFL', 'Closed' based upon the number of days the store is operational and this store status gets updated when a store upgrades/changes the status to other value. e.g new store x remains operational in same financial year for a year, the status upgrades from 'trading' to 'like for like LFL'.
We want to check the status of a store based on back-dated week in report independent of its current status.
Good morning -@Abhaivir Singh welcome to Tableau and to the forum - you will need to attach your workbook showing us what you have done to this point - we need a twbx format - also you sound very new to Tableau - please see the video at https://youtu.be/easBRzi9_bk "Jumpstart your Tableau Journey" it will help you with the transition from spreadsheet to Tableau and answer the question you raised
