Order of columns of Pivot result

[somersst]

Say I have the following table

Using the Pivot-functionality I should receive the following result.

But the result of the columbs is not always in the right order (1,2,3,4)

What is the logic that the Pivot-component used to determine this order, and how can I set it.

I already tried to sort on status, but this doesn't work for the order of columns

[cterenzi]

I would guess it is based on the order that the keys are encountered. Have you tried sorting the data before pivoting?

[somersst]

I discovered the problem. The fact was that I did the sorting before the aggregate component, which made the sorting break again

Sort->Aggregate->Pivot : WRONG

Aggregate->Sort->Pivot : OK