I am currently in the process of updating a tab in an exisiting dashboard. My issue with the process is that the current dashboard uses Standard calendar for all its tabs and the one I am updating requires the Fiscal calendar. How could I use both calendars in a dashboard. ? As this is my first dashboard, I am stuck with the basics. Any help would be useful.
Thank you Jonathan Dienst and Maximiliano Velez. It so happens that the master calendar has provisions for fiscal year and the std year format, all I had to do was create the values and set it to FIN_month to denote financial month.
I did try using the script given and it made the system slow. I am not sure of the reason behind it.