Calculated Dimention/Sort Order/Original

[lylererger]

Hi friends!

Help me to fix set analysis script of load order in chart.

Formula of calculated dimention is:

=Aggr( Only({1< _MENU_ПРОДУКТ = P({1<_MENU_СОРТИРОВКА ={$(=Concat('['&[_MENU_СОРТИРОВКА]&']',','))}>} )>} _MENU_ПРОДУКТ ), _MENU_ПРОДУКТ,_MENU_СОРТИРОВКА)

Sort Formula is:

Only({1< _MENU_ПРОДУКТ = P({1<_MENU_СОРТИРОВКА ={$(=Concat('['&[_MENU_СОРТИРОВКА]&']',','))}>} )>} _MENU_ПРОДУКТ )

Now menu looks like here:

But the product "КФЛ" should be on the first like:

I just need Original Load Order

Please help!

Thanks in advance!!!

P.S.: demo app in attachment...

[Anil_Babu_Samineni]

I don't have access to open your file, But can you try with "Load Order"checked in sort tab for Product?

[lylererger]

It is not working

[Anil_Babu_Samineni · Accepted solution]

PFA

[lylererger]

Thanks