Order in report by property

[Former Member]

Hi experts,

I want to show accounts on rows in my report with an specific order.

I have created a property in account dimension and I fill each account like: B001, B002...B00X, PL001, PL002...PLX.

Now I want to filter only accounts from B001 until B020 for example. Is possible to get this member with filter?

Maybe instead of "B001" should type only numbers? or Can I do with this type of name? How?

Thanks!!

[former_member186498 · Accepted solution]

Hi Alex,

not sure I've understood your request, but if you want to filter your account, in the filter panel (where you are) just choose the property from combobox, choose "between" as operator and "B001" "B020" for the values and high values.

After click on "add dynamic filter" button.

Regards

     Roberto

[Former Member · Accepted solution]

Thanks Roberto.

It works!