Hi Everyone How to use set analysis to sort some field's attribute?I dont want to use match function for these

[#1]

Hi Everyone

How to use set analysis to sort some field's attribute?I dont want to use match function for these

i have match function like this

Match(ancestor_name,'Total Assets','Fixed Assets less Accumulated Depreciation','Cash and Cash Equivalents','Current assets','Current Liabilities','Working capital',

'Operating working capital (ex FS)','Current Ratio (ex FS)','Net Worth','Working Capital Loans','Capital Employed','RONW %','ROCE %','Operating ROCE %','WACB %',

'Debt/ Equity','Interest coverage ratio','Debt/ EBITDA (ex FS)')

as i wanted then in my table as they are written,but problem is that when I'm selecting one field ,its position in the table got first,

i want to select them and as i select them it should be in that fixed position

thank you

[swuehl]

Not sure if I understand.

Set analysis purpose is to chose a working set of your data model for aggregations. It has nothing to do with sorting in principle.

So, to clarify your request, please tell us, how your field values look like, then where you want to sort the field (script / chart) and how the sort should work (by number / by text, by something else?).

[#3]

on sort tab

my  expression field have the logic of match function,i want to change it with set analysis

[bbi_mba_76]

Hi,

and if you load this dimension in the script with the correct order ?

Then you could use the load order to sort, or with the dual function.

[#5]

Hello BBI_MBA_76

my dimensions are attributes of a field 'str_description'

I can load str_description but how can i load attributes of str_description

[swuehl · Accepted solution]

You can create an inline table with the field values you are using in your match, and a second field that holds either the sort order as number or as a dual value. Then use the second field (when created as dual) as dimension.

Or try

=Match(only({1} ancestor_name),'Total Assets','Fixed Assets less Accumulated Depreciation','Cash and Cash Equivalents','Current assets','Current Liabilities','Working capital',

'Operating working capital (ex FS)','Current Ratio (ex FS)','Net Worth','Working Capital Loans','Capital Employed','RONW %','ROCE %','Operating ROCE %','WACB %',

'Debt/ Equity','Interest coverage ratio','Debt/ EBITDA (ex FS)')

[#7]

Thanks for the answer