Forum Discussion

Dellis81's avatar
Dellis81
Post Prodigy
4 years ago

reverse date hierachy

Hello!   I am wanting to reverse the normal order of columns (Dates) within matrix visual.  Traditionally I have used the date hierachy and really like those features.   Now, I am wanting to revers...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Dellis81 , Try if this can help. If not you have to create customer hierarchy with each column having a sort column

 

Date1 = [Date]

 

Sort Column = Rankx('Table', [Date],,desc,dense)

 

Mark sort column as column for date1 and use that

 

 

Or create year, month qtr etc 

 

Year1 = [Year]

 

Year Sort  = Rankx('Table', [Year],,desc,dense)

 

And create a hierarchy using such columns

  • Dellis81's avatar
    Dellis81
    Post Prodigy
    4 years ago

    Thank you for your response.   I have attempted several times on your suggestion.  I am able to creae a 'reverse date hierachy', but whenever I place this new hiearchy in in the column well - the order goes back to ascending.

    If I was to put the Reverse Yr Column (not use hiearchy), then I get what I expect.  I suspect the hiearchy feature does not allow for the customized sort.  Do you know if that holds true in non date hiearchies?

    Appreciate your help - sorry for slow response, I have tried off/on over the past few days - thinking I would eventually get it.  Your solution seems logical.  
    Thank you!