Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
single field or two fields?
Sory i didn't understand what you mean with that. My english isn't good
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
Jeremias,
As fisrt dimension select your group. Add a calculated second dimension:
=if(GetCurrentField('YourGroup')='D6', D5, if(GetCurrentField('YourGroup')='D5', D4, .......
Marc.
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?
Ah ok when i select dimension 5 i wanna two fields
Dimmension 4 / Dimension 5 / expressions
marc has already answered