Rank: Member
Groups: Registered
Joined: 2/19/2021(UTC) Posts: 10  Thanks: 2 times
|
Hey Eric,
How can i sort the columns in Pivot table with sortorder number
For example ->
In View result
Name PName Sort Count
ABC X 4 5
ABC Y 2 2
ABC Z 1 4
ABC A 3 7
Polo X 4 5
Polo Y 2 2
Polo Z 1 4
Polo A 3 7
Present Result (Seal report pivot)
Name A X Y Z
ABC 7 5 2 4
Polo 7 5 2 4
Expected Result
Name Z Y A X
ABC 4 2 7 5
Polo 4 2 7 5
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
well, custom sort can be done, but you have to :
- create a dedicated enumerated list on PName (using a SQL including SortNumber)
- set the enum property 'Use defined position to sort in reports' to true
it should then follow the new sort.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
