Is the dimension a text datatype or a date datatype ?
I'm thinking it might be text, so if you can make it date then it will automatically sort the way you want.
2 of 2 people found this helpful
Create the custom date in date field
Go to data window and sort directly with descending
Show filter and get latest month and year.
Thanks & Regards
BI,Aspire Systems India Pvt Ltd
Thanks for your kind response.
I already tried this option, once extract is refreshed the new date will be populated below in the date filter.
Then i need to do manually move the latest date to UP.
Default Properties >> sort >> Manual