On Viya you have the possibility to sort the data of a table through the custom sorting. But this has a limitation in case the data are so many. Among the requests I need to sort the data in a very specific order. In the database I have an attribute composed of numerical values that represents the order in which I have to display the elements of the table. In the normal table, thanks to the possibility of inserting this attribute as a hidden element, it allows me to sort the table elements for that element, but as far as the crosstab is concerned this is not possible and it is very complicated being a noteworthy database items using custom sorting.
Previously, the elements were followed by a numerical value, thanks to which the sort took place naturally without being modified. For the purposes of illustrating the data, this numerical value was removed, with the sole purpose of showing the ordered data, and the only solution is to use the custom sorting or it would be optimal to be able to insert a hidden element for the crosstab tables.
