I want make a static sorting on the pivot table as follow. I have 2 dimensions and 1 expression. I want sort the expression from high to low and also sort ascending with period dimension. See example below:
Period 200901 200902 200903 200904 200905 ...... Region A 1000 10000 100 1000 999 B 50 90 90 800 789 C 1 1 1 1 1
Have anybody experiense with this kind of sorting?
Go to Properties -> Sort. There you have different possibilities, by "Y"-value, i.e. following the expression, you may also sort alphabetically or by numeric value of them dimension. Another possibility you have under "Expression", where you may formulate your own expression, like {code]MATCH(Region, 'A', 'C', 'B')
Go to Properties -> Sort. There you have different possibilities, by "Y"-value, i.e. following the expression, you may also sort alphabetically or by numeric value of them dimension. Another possibility you have under "Expression", where you may formulate your own expression, like {code]MATCH(Region, 'A', 'C', 'B')
Thanks for the solution. On the first dimension i created a sort based on the expression -> AGGR(Sum (Waarde),[Werkorder & omschrijving], Jaar, Maand) The second dimension i sorted numeric ascending on the period. Now i have the result that i wanted.
