nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Month is not in Proper

princeabd

Hi All,

I am trying to generate a report in month wise,
But MONTH IS NOT IN PROPER ORDER IN CROSS TAB,

Its coming Alphabetical order by default,
How to order.

Plz help me on this,

Regards,
Jeyinul.

Find more posts tagged with

Comments

mwilliams

How are you creating the month dimension? If you have a date field and use the month grouping, it should be in order. If you just have a field like Jan, Feb, Mar, etc. You can create a computed column that gives you 1, 2, 3, etc. depending on the month, then in your dataCube, select the string month dimension, select edit and add the new numeric field as an attribute to the dimension. Finally, in your crosstab, sort the dimension by the attribute you assigned to it.

princeabd

How to create a computed column.Plz give more explanation about this with snop shots. 
Thanks, 
Jeyinul. 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="80924" data-time="1312294130" data-date="02 August 2011 - 07:08 AM">
How are you creating the month dimension? If you have a date field and use the month grouping, it should be in order. If you just have a field like Jan, Feb, Mar, etc. You can create a computed column that gives you 1, 2, 3, etc. depending on the month, then in your dataCube, select the string month dimension, select edit and add the new numeric field as an attribute to the dimension. Finally, in your crosstab, sort the dimension by the attribute you assigned to it. </blockquote>

wwilliams

<blockquote class='ipsBlockquote' data-author="'princeabd'" data-cid="81009" data-time="1312345627" data-date="02 August 2011 - 09:27 PM">
How to create a computed column.Plz give more explanation about this with snop shots. 
Thanks, 
Jeyinul. </blockquote>
 
You could also do it in your SQL, Oracle: to_char(mydate,'MM') 
 
Javascript; 
dataSetRow["mydate"].getMonth() 
(January =0) 
 
-W

mwilliams

To create a computed column, simply open up your dataSet editor and go to the computed column section and add a computed column.