autonumbering

[#1]

Dear all,

I need your advice about the following problem:
I have 3 dimensions in a pivot table (Country, DelivDate,DelivMaterial) and I need to add a field for autonumbering related only to the first two dimensions(Country, DelivDate).
At each change with the 'Country' the numbering should start with '1'and at each change
of 'DelivDate' the numbering should increase with '1'.
I thought about using Ronum(), but it doesn't work with 3 dimensions, only when there are two.

Kalin

[biester]

Hi Kalin,

just to be sure I'm getting you right an example (in brackets the autonumbered field):

Belgium 1.7.09 (1) Material A
Belgium 2.7.09 (2) Material B
Austria 5.7.09 (1) Material ...
Austria 6.7.09 (2) ......
Austria 7.7.09 (3) ....
Germany 1.7.09 (1)

Have you already tried with the peek() function - I think it would be better to do this in the script (also because of better performance)? Perhaps the purpose of your demand would give a better insight.

Rgds

Joachim

[#3]

Biester, thank you very much about answering and helping me.

To be honest it took me so long to answer, because I was experimenting with different approaches the PEEK function.

I've got what I needed with the PEEK, implementing it in a IF condition:

LOAD

PRODUCT,

DATE,

QTY,

If(Peek(Product)<>Product,1,Peek(Numbering)+1)

Group by Product, Date

Resident TRANSACTIONS;

Drop TRANSACTIONS;

Have a nice week-end!

Kalin

[biester]

Hi Kalin,

as I see your experimenting suceeded. Your script is just the way I had in mind.

Rgds,
Joachim

P.S.: Weekend's already over now, unfortunately ;-(