Hi Arnab Chaudhury ,
You can create a new fiscal year as per your requirements .
Sharing the link ::
Please have a look .
Thanks, Nikher for the info.
However, this needs to be dynamic. I need to change the fiscal year start date as per the country selected from filter.
Also, it has to be line chart, with drill up and down feature and the axis need to start from the country fiscal month start .
1 of 1 people found this helpful
- 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.
This is a mock data containing only 3 countries. Actual data contains 150+ counties. Also fiscal start date for each country may change. There is separate table containing the fiscal start date for each country.
2 of 2 people found this helpful
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
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.
The solution is really helpful. However could you please tell how to implement a drill up and down the date?
This is of great help!! Could you please share the latest workbook whose screenshot you are showing.
Thanks in advance.