Today one of my Colleague asked me, how to sort month column in generic way i.e Jan --> Dec. This we can achieve using "Sort Order Column" option in BMM layer. It is a common requirement to display one field while sort by another.
For example Month Names comes Jan > Feb > Mar, etc should always be sorted by Month Number and not the Month Name. Then you can do this....
Open RPD > Navigate to the "Month Name" in logical layer > open column properties > click on General Tab > Specify "Month Number" in 'Sort Order Column'
For example Month Names comes Jan > Feb > Mar, etc should always be sorted by Month Number and not the Month Name. Then you can do this....
Open RPD > Navigate to the "Month Name" in logical layer > open column properties > click on General Tab > Specify "Month Number" in 'Sort Order Column'
Below screen will show you the steps......
.
This comment has been removed by the author.
ReplyDelete