Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi Cathleen
You can use sort by numerical value descending order which will sort all you month values properly.
Many Thanks
Karthik
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.
Thank you
May be use the expression MakeDate(Year,Month,1) in the sort page
Ah ok, you mean that you don't already have a Date field ?
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))
Hi, I created a new Date field: MakeDate(JahrT,MonatT) . Now I want to sort the new Date field in the correct sequence
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