Concat and Sort Year-Month

[#1]

Hi every one

i need to join two field Year and Month

my year is shamsi year

and my month is 'فروردین - اردیبهشت - خرداد - تیر - مرداد - شهریور - مهر - آبان ـ آذر - دی - بهمن ـ‌اسفند'

after concatenate i have one field like "1394فروردین"

i want when i choose 2 year, i see in my dimension from first month of max year up to last month of max year

and then first month of previous year up to last month of previous year.

sort is like below :

1394 فروردین

1394 اردیبهشت

1394 خرداد

1394 تیر

1394 مرداد

1394 شهریور

1393 فروردین

1393 اردیبهشت

1393 خرداد

...

please help me

Best Regards

Hamide

[hic]

I suggest you take a look at the files posted on Non-Gregorian calendars. Among them is a script that generates a Shamsi (Persian) calendar, including a field "YearMonth".

The script uses the latinized Farsi month names, but it is easy to change it to use Farsi script. Just change

// Farsi    as MonthName,

   [Farsi Latin script]  as MonthName,

to

  Farsi    as MonthName,

// [Farsi Latin script]  as MonthName,

HIC

[ramasaisaksoft]

Hi Ghadimabadi,

Try to sort this column/Dimension  as per year field.

so that all table fields in a chart are changed.

[saimahasan]

Hi

If you can create a new numeric field for the Year month field:

Say for eg... you have this field saved as YearMonth, then create a new field [Sort YearMonth] as num(YearMonth) and then sort the field YearMonth as per the field [Sort YearMonth] in the expressions under sort tab.