Personal sorting of Columns in Pivot created

[#1]

Hi,

I have created a pivot table, in order to create a "time line" of the progress of a claim as it goes through different claim stages. However, the "Claim statuses" are sorted in alphabetical order. how can a change these to the way they should be?  any means to fix this or does someone have a better way to indicate this info. The data will be used to track performance per stage.

[marcus_sommer]

You need to create a numeric sort-information to your string-values. You could use a sorting-table like:

Sort:

Load *, rowno() as NumericStatus Inline [

Claim statuses

A

B

C

...

];

or you used a dual() function like:

dual([Claim statuses], pick(match([Claim statuses], 'A', 'B', 'C', ...), 1, 2, 3, ...)) as [Claim statuses]

then you could use avg(NumericStatus) as sort-expression or by the dual you could simply sort [Claim statuses] numeric.

- Marcus