Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Month list box associated with a time dimension. This list box is based on a trading calendar not fiscal. In this instance the first month is July etc. To ensure that the list box shows July first i have in the "sort" properties i have ticked "expressions" and made this "=Period" where period is a number from 1-12.
The problem i have is that when the window pops up the list box is correct i.e. July is in position 1, Aug in 2 etc, however as soon as a "click" on July it moves out of position in the list box....how can I "fix" it in that position?
As long as all items can be displayed in the listbox, just untick "State" in the sorting-tab.
HTH
Peter
in the sort tab
un check the top check box
sort by State
Hi Peter, all items are displayed and the "state" box is unchecked, however, it is still not holding the positions? Very odd
Were you ever able to find a solution to this?