Hello, When you use CALENDARAUTO () you have the option to supply your financial year end month, so CALENDARAUTO(3) for march. However when a date hierarchy is created on your date table the quarters are still based on the jan-dec values. Clearly, if I set my financial beginning of the year as April, then April-May-June are the first quarter, not Jan-Feb-March as the auto date hierarchy creates it.
1 Comment
- Status added:Needs Votes
