Problem sorting dimension drilldown

[mfikrirahmat]

Dear All,

i have a same problem for the sorting dimension drilldown.

field :

1. MonthYear

2. ID_BANK (Primary key)

why field ID_BANK first one sort  always position ?

i need first one sort monthyear position

thank for help

[jonathandienst]

Set the sort order for the drill down group elements using the "Sort Orders..." button the the group edit screen:

[mfikrirahmat]

i'm to try this (check uncheck) , but not working sorting position

[Anil_Babu_Samineni]

Un-Check the State Ascending

[mfikrirahmat]

i'm trying this, but not work , i need first one display dimension monthyear ,

[Siva_Sankar]

Can you upload an example?

Siva

[prieper]

Would you please verify, that MonthYear is a numeric field?

Peter

[mfikrirahmat]

value monthyear = May 2016

[mfikrirahmat]

the file is very bid , i con not upload

this screenshoot

i want the first to appear dimension monthyear , not id_bank

[Siva_Sankar]

Ok.

Select Edit group from the dimension,

then select and highlight the  group (in your case DW_GWMLFR)

then Edit again, Group settings dialog box will open

in Group settings dialog box, you will see the fields MonthYear and IDBank,

Select MonthYear and hit promote button. Click ok

Siva