matrix table - Direct Query

[Anonymous]

hi all,

is there a possibility to sort by hidden col ?

in matrix table ->the column is "age_desc" (dim) .

I want to sort by "age_id" (hidden) or "age_desc" 

but allowing only sort by :company_code&name .

Thanks, sinayh

[Anonymous]

This may help.

On the data tab, you can use 'Sort by Column' that dictates the sort and impacts any visuals that it's in.

[Anonymous]

hi, thank you for your response.

It's inaccessible, gray.

[Anonymous]

you have to select the field you want to sort and this will make it available - then choose the variable from the drop down that you want to sort by.

[Anonymous]

hi,  Sorry I may not understand though.

It may be related to - direct query?

Unable to click - age_desc (2).

And even when I choose "company" (1) a sorting - Still gray 😞

[Anonymous · Accepted solution]

you need to be in the data tab for it to work - but you may have limited access in there because of the direct query.

[Anonymous]

Wow thank you very much ((: