Sorting Axis

[caniwhz1]

Hallo,

I hope anybody can help me.

How can I sorting the axis in the Diagramm?

The dimension of the axis consists of the combination of the fields year & month. I want to display the months of each year in the logical order (Starting for example with 2016January,2016 February ..than 2017January...and so on.).

Thank you very much in advance for help.

[YoussefBelloum]

Hi,

I suppose that you have Date field, on the sorting options, uncheck all and put this expression on ascending:

=Max(Date)

PS: Date is your Date field, so if it not called Date, Use your Date field name.

[karthikoffi27se]

Hi Cathleen

You can use sort by numerical value descending order which will sort all you month values properly.

Many Thanks

Karthik

[caniwhz1]

Hi,

thank you for the Information.

I can use this formula if I only select a date field (Year or Month). But I have two columns (year and month) which I would like to combine (year & month) and then want to show sorted.

I have Change the Diagramm.

Have a nice day.

[caniwhz1]

Thank you

[sasiparupudi1]

May be use the expression MakeDate(Year,Month,1) in the sort page

[YoussefBelloum]

Ah ok, you mean that you don't already have a Date field ?

[caniwhz1]

I have connected year and month as a data field (makeDate). However, sorting with the formula "max (date)" does not work

I used the following Expression (I got an error)

=Max(MakeDate(JahrT,MonatT))

[caniwhz1]

Hi, I created a new Date field: MakeDate(JahrT,MonatT) . Now I want to sort the new Date field in the correct sequence

[YoussefBelloum]

it does not work because your Month field are not numeric..

try this:

=MakeDate(JahrT,num(month(date#(MonatT,'MMM'))))

and try to use it on the sorting with max