Sorting issue in date

[prma7799]

Hi All,

I have taken invoice date and more 5 fields as dimension my requirement is that I want data sorting as by Invoce date.

For that I took  = num(month([First Invioce Date])) dimension in first column but data is not sorted as per our requirement.

My expected output is

sorted data should come as apr-14

                                         May-14

                                          aug-14

                                           ................

                                       apr 15 like this.

But still am getting below sorting which not correct. Please help

[prma7799]

Any help on this

[swuehl]

The sorting should be correct anyway if you follow previous recommendation.

If you want to create a fiscal year calendar, with year starting in april, have a look at

Fiscal Year

[#4]

First  Make sure [First Invioce Date] field format  is strinig or Date .

If  it is string then  use Date# & Date function to conver string to date  then  it  will wrok .

Num(date(date#([First Invioce Date],'DD/MM/YYYY')))
this expression use in sort tab-> expression

I hope it will work

[settu_periasamy]

May be try this, in your Sort -> Expression

=Date(Date#([First Invioce Date],'DD/MM/YYYY'))

remove the other sort

[prma7799]

Sort is coming from August means 8 5 3 2 like this

August

may

march

feb

I want data should come like below

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Jan

Feb

Mar

Thanks

[settu_periasamy]

I didn't mean the 'Sort' FieldName(In picture)

Chart Properties -> Sort Tab -> Promote your 'Invoice Data' Field to top. ->

In the Expression

=Date(Date#([First Invioce Date],'DD/MM/YYYY'))

-> Ascending

[#8]

Hi,

Add these lines in master calendar

Set vFiscalMonthStart = 4 ; 

Calendar:
Load Dual(_fiscalYear-1 &'/'& _fiscalYear, _fiscalYear) as FiscalYear,       

         Dual(Month, _fiscalMonth)                as FiscalMonth,        
          *;
Load Year + If(Month>=$(vFiscalMonthStart ), 1, 0) as _fiscalYear,         
         Mod(Month-$(vFiscalMonthStart ), 12)+1        as _fiscalMonth,        
          *;

Load * from MasterCalender;

and use FiscalYear&FiscalMonth  in sort tab under expression.

[elakkians]

What you are looking can be achieved by creating fiscal calendar , which has April as the starting month ,

take a look at this

Fiscal and Standard Calendar generation 

[settu_periasamy]

Hi,

Give the same expression which you have used in First Invoice Date:

Chart Properties -> Sort Tab -> Promote your 'Invoice Data' Field to top. ->

In the Expression

=If(date([First Invioce Date])>=Date(vStartDate) and date([First Invioce Date])<=Date(vEndDate),

date([First Invioce Date]))

=> Ascending

[buzzy996]

try to sort ur Invoice date in script it self, by using order by invoice date and in sort tab use Load order check box as Original.

hth