How to have a fixed sort order in straight table based on dimension values

[Anonymous]

Hi,

I have a straight table with 1 Dimension and 6 Expressions.

Soring has to be done on the dimension, the order has to be fixed on any selection.

can some please suggest me how to do this asap.

Thanks!

[Marcio_Campestrini]

Hi Chinnukool

Try to define your sort order and then disable the "Allow interactive sort' option.

[Frank_Hartmann]

please share a sample! (if u cannot share make samplefile with modification of your dataset)

without knowing your datamodel its gonna be difficult to give advice!

[Marcio_Campestrini · Accepted solution]

Hi chinnukool

Create an inline table at the beginning of the script with the below structure:

OrderTitle:

Load * Inline [

   Title

    Partner

    Of Counsel

    Associate

    Paralegal ];

And at the end of the script drop this table.

In the chart properties, at sort tab, unmark all options but 'Load Order', and choose 'Original'.

[#5]

Hi Chinnukool,

You have to just create an inline table with 2 columns.

OrderTitle:

Load * Inline [

   Title, SortOrder

    Partner,1

    Of Counsel,2

    Associate,3

    Paralegal ,4];

Now sort it on the SortOrder column.

[Anonymous]

That worked! thanks much for your help!