I have given year heirarchy as inherited ascending format ,month as inherit ascending format and date when I have given Ascending Formated ,days are coming fine but still the month are not coming in sorted order. I tried to give all the possible format available to the month column level but all in vain....Nothing changed. I also added the option include the missing value as you mentioned but that also not working properly.
... View more