Month order in list

[#1]

Hi All,

I have a list box in which am showing months. I have two fields comming my load script for month - One has months names(Jan, Feb etc) and the other has numeric values ofr months(1,2 etc). In the list, am using the month name(Jan, Feb) but sorting by the month number to get them sorted correctly and it workes fine.

However, when I slect a month in the list box, the order is gone. Any thoughts on how to fix this? Thanks in advance!

[phaneendra_kunc]

so you must have used sort expression to sort the Month name by your Month Number..

Use sort expressions as = sum ({1} Month number Field)

that will do it....

[#3]

Thank you - that did the trick. Can you please explain me how it works?

[phaneendra_kunc · Accepted solution]

It is just a set statement...

1 means ignore current selections.....

In your case if you choose any month name that will filters the Month number according to your selection...so for the rest of the months that number will be NULL/Invalid...

Hit F1 and search for Set Analsysis...

sum( {$} Sales )
returns sales for the current selection, i.e. the same as sum(Sales).

sum( {$1} Sales )
returns sales for the previous selection.

sum( {$_2} Sales )
returns sales for the 2nd next selection, i.e. two steps forward. Only relevant if you just made two Back operations.

sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value.

sum( {1} Total Sales )
returns total sales within the application, disregarding both selection and dimension. I.e. the same as sum(All Sales).

sum( {BM01} Sales )
returns sales for the bookmark BM01.

sum( {MyBookMark} Sales )
returns sales for the bookmark MyBookMark.

sum({Server\BM01} Sales)
returns the sales for the server bookmark BM01.

sum({Document\MyBookmark}Sales)
returns the sales for the document bookmark MyBookmark.

And mark this thread as answered if the solution works for you. so that community people will know where to find the answers for similar answers...!!!

Happy Learning