4) Create new order date (e.g. if current year is 2023 then make sure new order date should have 2023) and show below columns in the text table. • Year • Quarter • Month • SUM(Sales) • YTD Sales • QTD Sales • MTD Sales

Hi,

I would need more details to help you further however, this link might help you:

https://help.tableau.com/current/pro/desktop/en-us/functions_functions_date.htm

These will help you change your order date in your data.