Sorting issue

[#1]

Hi All,

I have 10 dimensions in a straight table.I have sort on first priority dimension (which works). Next few i don't sort. There is a sort bottom down the priority (date based on Ascending). Will this work? It is Version 11.2

Sai.

[sushil353]

Hi,

In sort tab you can promote or Demote your desired hierarchy of dimensions..

HTH

Sushil

[rwunderlich]

Yes, it should. Are you experiencing any specific difficulty?

-Rob

[amit_saini]

Sai,

I would suggest here to give condition while sorting, check if this will help you.

Thanks,
AS

[#5]

It shows me the sorted order when I choose the dropdown. It does not show me in the table though.

[sushil353 · Accepted solution]

In the Sort Tab>Sort by Expression..

Try this: Date(TakeOn)

or Date(Date#(Takeon,'DD-MMM-YYYY'))

HTH

Sushil