Forum Discussion
sort months using calendar data source column
Anonymous My suggestion "explicitly" defines the columns and uses for them. The date hierarchy default "implicitly" handles the conversion. Your current INT column won't work sorting against a YearMonth because it is more granular. (you'll get an error).
You need to add both these columns to your calendar table.
YearMonth for display
YearMonthNumber for sorting the YearMonth display column.
Hi Anonymous
Thank you for the reply.
But do I not already have that column? the INT? using the correct format?
Just to clarify, in which table do I need to add the YearMonth column you mentioned?
And where do I add the sort INT column with YearMonthNumber that you also mentioned after that?
It is still a little confusing for me. My apologies.
Thank you.
J
Anonymous My suggestion "explicitly" defines the columns and uses for them. The date hierarchy default "implicitly" handles the conversion. Your current INT column won't work sorting against a YearMonth because it is more granular. (you'll get an error).
You need to add both these columns to your calendar table.
YearMonth for display
YearMonthNumber for sorting the YearMonth display column.
That;s exactly it.
Thank you for your time and patience.
Kind regards,
Joaquim