Sorting calculated dimension

[prasadreddy]

  Hi All,

Below is my calculated dimension, so, i want to sort the bar chart by 'Month_Name' wise,

Month contains the data like: 201301, 201302, 201303, 201304

Month_Name: Jan, Feb, Mar, Apr

Please update me ASAP,

Thanks in advance

=

IF($(v_OVar1) = 0,

Month_Name& '-' &

Left(

[Month],4),

IF(

FY_Quarter='Q1',

Qtr_Month,

IF(

FY_Quarter='Q2',

Qtr_Month,

IF(

FY_Quarter='Q3',

Qtr_Month,

IF(

FY_Quarter='Q4',

Qtr_Month
))))
)

[bbi_mba_76]

Hi,

you could use the dual function or load the data in the correct order, so you could sort by load order

[israrkhan]

as Barini said above, one more idea is you can load inline like,

LOAD * INLINE[

NO, MONTH

1, Jan

2, feb,

3, mar

...

....

....and so

];

THEN USE EXPRESSION IN YOUR SORT ORDER, ON NO...

[Anonymous]

Israr

Or simply sort using expression :

     num(mid( [Month] ,5,2))

or you could use this expression if you prefer:

     num(month(date#( [Month_Name] ,'MMM')))

Best Regards,     Bill

[prasadreddy]

Hi Bill,

In my bar chart, it should show months on X-axes, but it showing order like,

Feb, Mar, Jan, Dec, Nov,

But i want to show like:

Nov,  Dec, Jan, Feb, Mar,

[saumyashah90]

in properties Sort->Numeric Value

[tresesco]

If your sort order is fixed as Nov, Dec, Jan... Then in the sort tab select your calculated dimension and write in expression : =Match(Month_Name, 'Nov','Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct')

If this does not work, please share your sample app.

[bbi_mba_76]

Hi, you have to add the year, I think Nov and Dec are 2012, whereas the other month are related to 2013.

[CELAMBARASAN]

You can use something like

IF($(v_OVar1) = 0,

Dual(Month_Name& '-' &

Left(

[Month],4), [Month])..

[prasadreddy]

Hi tresesco,

I tried this, but still it is showing order like:

Feb, Mar, Jan, Dec, Nov,