Ascending and Descending Order

building reports webintelligence
1

Hello All

there is a requirement that date is sorted in a 2 different orders -

there is one column Date in YYYY-MM-dd format
business wants Months should be sorted in Descending order like Dec, Nov, Oct ~ Jan

And under same column Dates should be sorted Ascesnding i.e. for Dec it should be 1 Dec, 2 dec ~ 31 dec 1 Nov ~30 Nov

Is this possible in webi?

zgoyal14 :india: (BOB member since 2011-08-03)

2

Create two variables. Breakout the months(number) into one column and Days of Month in another from the original date column. Apply your sorts to the new columns then hide the columns if not desired.

You could also use a break or section on month and sort days within the break or section.

datawizard (BOB member since 2015-01-20)

3

Yes.

Create a year-month variable in yyyy-MM format.
Sort on that descending, then sort on your original date object as your secondary sort. :slight_smile:

4

Great Thanks a lot for the Reply :slight_smile:

zgoyal14 :india: (BOB member since 2011-08-03)