Tableau doesn't have provisions for that.
You'll have to simulate it with your own date calc fields.
But how do you expect to show an overall FYTD total when some countries start on January and some start on February? What does FYTD even mean in January when some countries have only one month on the books, and others have 12?
If that example means you'll add only January data for a January FY start, but add fully 12 months for a country with a February FY, you CAN make that happen. The WINDOW_SUM function lets you add from the current mark to some prior mark, and you can specify that offset with a calc, and the calc can be conditionally set based on the country in question.
I'm tossing these ideas out only at the conceptual level. I would need an actual sample workbook to play with it and try things out.
There is no straight forward way to do this. you can duplicate the field and set one of the dates FY start as Jan other as Feb and create 2 sheets one with countries with date1 other with Date2 only with the countries corresponding to the certain FY start
Is data only aggregated and compared at month level? If so...when prepare dataset, can you add a calculated field for Fiscal Date? Data should look like this. Then you can use FiscalDate rather than the real date of transaction. Hope that helps.
Country Order Date FiscalDate Brazil 20160101 20160101 Brazil 20160130 20160101 NA 20160202 20160101 NA 20160330 20160201
It might make sense to create a hierarchy of calculated dimensions for Year, Quarter, Month, and Day.
1. Duplicate your Date Field
2. Change your FYs for each separate Date Field
3. Create Year Calc:
IF [Country] = "Brazil" THEN YEAR(Date1) ELSE YEAR(Date2) END
4-6. Create Quarter, Month, Day calcs (All similar, other than Quarter calc requires DATEPART('quarter',datefield) )
7. Create hierarchy, and use those fields.
Not completely sure this solves the problem, but It would let you compare "month 5" from different FY's pretty easily.