Horizontal Sorting

[Former Member]

Hi

Is there any possibility of horizontal sort?

If I select a table at "Properties" I see "Priority Management" and see you can choose the priority in the vertical and horizontal sorts.

Verticals are not a problem, but .... How I can define a horizontal management?

If I had this information and would like to sort by the year ..., how could I do?

	Year 1	Year 2	Year 3
Shop 1	1000	1450	1500
Shop 2	800	600	500
Shop 3	750	900	700
Total	2550	2950	2700

at

	Year 2	Year 3	Year 1
Shop 1	1450	1500	1000
Shop 2	600	500	800
Sjop 3	900	700	750
Total	2950	2700	2550

[Former Member]

Hi Adolfo Sanz ,

Here what you are looking for is dynamic column placement and not a data sorting. The horizontal sorting is just a data sorting but only applicable for horizontal table lay out ...

To achieve this you can use some improvised variable and build your table using those variable ..This process is fairly simple but need much more work than normal table..

For example for coulmn 1 you will have to define a variable like below .. You will have to make a header similarly as well

= If sum([Revenue]) in ([Year1]) = max( sum([Revenue]) in ([Year])  )  forall ([years]) ) then [Year1]

else if sum([Revenue]) in ([Year2]) = max( sum([Revenue]) in ([Year])  )  forall ([years]) ) then [Year2]

esle [Year3]

This process should work as long as you have lesser number of columns to sort howver for more columns it will result in just too much additional work..