Doubt with ciclic dimension

[#1]

How if for example i have 6 dimensions in a ciclic dimmension

D1,D2,D3,D4,D5,D5

Is it possible to have the selected dimmension + the previous dimmension ?

for example if i'm in dimmension 5 in the table i'd see

Dimmension 4 // Dimension 5

etc..

Thank you,

greetings

[#2]

Sory i realized that is a jerarquic expression not ciclic. Is it the same ?

[Anonymous]

exactly the same.

[#4]

It doesn't work! I'll atach an example in the original message, because i couldn't atach it here

[#5]

It is here!

[#6]

Thank you

Do you know why it doesn't work ?

[Anonymous · Accepted solution]

Jeremias,

My fault. Do not use comas inside GetCurrentField funtion:

=if(GetCurrentField(YourGroup)='D6', D5, if(GetCurrentField(YourGroup)='D5', D4, .......

Marc.

[Edit] Please Find Attached

[sunny_talwar]

You don't need to use single quotes within the GetCurrentField. Try this:

=if(GetCurrentField(J)='DIM4', DIM3,

     if(GetCurrentField(J)='DIM3', DIM2,

          if(GetCurrentField(J)='DIM2', DIM1)))

Best,

S