Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In the Sort Tab>Sort by Expression..
Try this: Date(TakeOn)
or Date(Date#(Takeon,'DD-MMM-YYYY'))
HTH
Sushil
Hi,
In sort tab you can promote or Demote your desired hierarchy of dimensions..
HTH
Sushil
Yes, it should. Are you experiencing any specific difficulty?
-Rob
Sai,
I would suggest here to give condition while sorting, check if this will help you.
Thanks,
AS
It shows me the sorted order when I choose the dropdown. It does not show me in the table though.
In the Sort Tab>Sort by Expression..
Try this: Date(TakeOn)
or Date(Date#(Takeon,'DD-MMM-YYYY'))
HTH
Sushil