Hi Arnab Chaudhury ,

You can create a new fiscal year as per your requirements .

Sharing the link ::

https://interworks.com/blog/rcurtis/2017/02/10/tableau-deep-dive-dates-custom-dates/

Please have a look .

-Nikher Verma

Hello Arnab,

- Duplicate your date field 3 times for each country. Set start of the fiscal year for the respective date field.

e.g. Date_China -> June etc.

- Create one parameter for the country.

- Create 3 different charts for 3 different states using different date fields created earlier. and use hide and show functionality using the parameter.

So finally you will be having 3 charts for 3 countries with the respective start of the fiscal year.

Hope this suffices.

Sonali

Good morning - please see the attached approach

it will return this for example

there are several calculations and I added a date ladder

first the data ladder - is just an excel file with a long list of dates to create a continuous date range that would cover the period

then the Start Date (the month and year of the fiscal month and year in the view

then a filter to limit the output to start at the Fiscal Month start and run for 2 years (this is arbitrary it is just a longer period than in your date year selector

to create the view

Place the Date ladder on the columns

and the filter set to true

I noticed you have 150 countries - you could use a country parameter to select the country and back it up with a calculated field for a filter

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Just put the "DATE" pill on columns - either discrete or continuous

discrete

continuous

Jim