start by a particular month

[#1]

  Hi everybody,

I have a question, i have two strings and i use a calendar as you can see on the left of the screen shot.

So the selection of the date is "01/10/2014" to "30/06/2015", so i want the same table like the screen shot but i want the table start by the first month of the selection (octobre in this selection)

So i would like the field "LVR.mois" start in this case?

Oct

Nov

Dec

Jan

Fev

Mars

Avril

Mai

Juin

How can i do that? thanks a lot!

[Anonymous]

Hi,

I think is simplier if you post a sample data.

Regards.

[MK_QSL]

You need to use MonthYear instead of Month something like below

Date(MonthStart([Invoice Date]),'YYYYMM') as InvoiceYearMonth;

[lironbaram]

hi you could use an expression for the month field sorting

in the sort tab of the chart properties

for the month field check sort by expression

and use this expression : max(Date)

[#5]

I post a sample!

thanks a lot

[#6]

Up please!

[lironbaram · Accepted solution]

hi

have a look at the attach example

[avinashelite]

Hi Sab,

Go to chrt properties>sort> select the LVR.mois>Expression > and paste this " Min( [LVR.Date d_expédition])"

that will do

[#9]

Thanks a lot liron and Avirash it works!!!!!!

[avinashelite]

cool if you got the answer mark its helpful and correct