I have created a dashboard prompt with a calendar date column. The user's requirement is to display the sales of Previous financial year Last day i.e 31st March of year for the prompted date.
How this is achievable? Please reply anyone having the logic implemented.
Financial year starts from 01 Apr.