TM1 Forum

Hello,

is it possible to change the sort of the elements on different columns and asc/desc?
In Excel I do have the Name SL01FILT wich can be changed to changed the sorting. But how can I do that in TM1Web?

Thanks a lot,

Toto

Hi Toto,

When a websheet is uploaded to the web there is no idea of selecting a column and doing a dynamic sort, however, there are a number of different ways to achieve this,

1. Static Subsets - create a subset in the order required, asc or desc or any order at all; and then reference this via formula for the row data with subnm
this enables a user to input the "sort name" or enter a 1 next to the appropriate sort.

2. Action Buttons - when a dynamic sort is required, allow the user to enter which columns are required to be sorted and in which order, then click on an action button, the action button TI would then create an appropriately ordered subset.

HTH
Neil

Hello Neil,

thanks a lot for your answer. Does this only work for active forms or for slices as well?

I am using 9.5.1. When I export a slice it is always generated as classic slice. For the row it seems that I have a static list of elements. So here I could not change the order, correct?

Thanks!