Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Doubt with ciclic dimension

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

16 Replies
sunny_talwar

As per my knowledge there is no way to have a single group display two fields at one time. If you don't mind me asking, why is this required? May be there is another way to achieve what your final goal might be.

Best,

S

maxgro
MVP
MVP

single field or two fields?

Not applicable
Author

Sory i didn't understand what you mean with that. My english isn't good

Not applicable
Author

I have to put two small graphics in the right and the table in the left and in the pivot table i have a lot of dimensions.

If i use the normal pivot table i dont have place to the graphics

Anonymous
Not applicable
Author

Jeremias,

As fisrt dimension select your group. Add a calculated second dimension:

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

Marc.

maxgro
MVP
MVP

when you select dimension 5

do you want two fields,                dimension4     dimension5

or do you only want one field       dimension5 with the values of dimension 4 e 5?

sunny_talwar

Did not think about this. Kudos marcarreras

Best,

S

Not applicable
Author

Ah ok when i select dimension 5 i wanna two fields

Dimmension 4 / Dimension 5 / expressions

maxgro
MVP
MVP

marc has already answered