Forum Discussion
Filter Date Ordering
Hi all, I have a report where I use a (generated) date table which works fine but I have encountered a slight problem with the filtering. Refering to the picture above; The month names are ...
Hi Anonymous,
After creating your calculated column, you can find sortbycolumn option under modeling tab from there you need to sort your MonthName column based on MonthID. Please find the below screenshots FYR.
Before Sort:
Sort by MonthID:
After Sort:
Hi Anonymous,
After creating your calculated column, you can find sortbycolumn option under modeling tab from there you need to sort your MonthName column based on MonthID. Please find the below screenshots FYR.
Before Sort:
Sort by MonthID:
After Sort:
Thanks for the help Anonymous! This resulted in the outcome I was looking for.