Group orders by customers order count

[#1]

I have a table with orders which contains OrderDate, OrderNumber and CustomerNr

I want a chart similar to the image. The first column should group customers order count. Meaning the first row, 1, should show every customers first order. 2 should show only "2nd orders".

The expression i have used so far, as a dimension, is: Aggr(RowNo(), CustomerNr, OrderDate)

However, I cant get it right. As you see, the order isnt correct if you look at the dates. Customer 001015534 have made two orders. The order made 2010-12-10 should be the 1st and the order 2012-05-24 the 2nd. Now its the other way around.

How can I fix this? Is it better to solve in the script and how?

Thanks

[whiteline]

Hi.

I guess that Aggr() function uses LoadOrder for sorting.

Try to order your data by OrderDate in script.

[#3]

Hi whiteline

I tried this but still the same results.

[#4]

Any way to solve this in the script instead?