Thank you for your help..
I had changed my fiscal year at data source date properties still it is taking starting month as January in calculations but when we use the date column in sheet it gives the correct values but I cant use date in the sheet.
1 of 1 people found this helpful
Tableau is a great tool to build visualizations but not always to perform calculations. Sometimes it's better to directly perform the calculation you need outside Tableau (in the dababase/ spreasheet) you're using. However in your case you need to translate your fiscal year to a calendar year, so that the calculation will work in tableau. These 2 community conversations explain how to do it:
Hope it helps,