Monday, October 29, 2012

SSAS - Sort year columns in descending order

Create a calculated field
Calculate a new sort index as 0-year
Use it as an attribute to sort
See this post for full instructions

http://sql-bi-dev.blogspot.com/2010/05/sort-dimension-members-in-descending.html

No comments:

Post a Comment