Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I am developing a dashboard unfortunately I am unable to sort out the bars in a chart. I want them in chronological order. like Oct/16 , Nov /16, Dec 17. The values used for calculations are CompleteMonthNamesRefRcvd and CompleteYearNameRcvd.
I have attached the screen shots please review them.
Kind Regards
Waqas Shah
Try like:
Dual(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)) ,
Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(RIGHT(CompleteYearNamesRefRcvd,2)), 'MMM/YY'))
Try with this
Load
Date(Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&RIGHT(CompleteYearNamesRefRcvd,2),'MMM/YY')'MMM/YY') as FielName
From Source;
In sort use
=Date#(Left(CompleteMonthNamesRefRcvd,3)&'/'&Right(CompleteYearNamesRefRcvd,2),'MMM/YY')