The quotes is obsolete, so the right expression is:
Everithing works fine.
I get the message Error dimension
Don't understand. Why did you try to place this expression as calculated dimension ?
CyclicGroupAggr.png 3.7 K
Thanks!!! it works fine.
What I'm trying to do is a pivot with dynamic dimensions, using a cycle group.
Having one dimension only (for example customer), the TOTALSALES is aggr (sum(salesamount), Customer).
If I want to do the same for another dimension, I've to create another pivot and my aggr became
So I would have just one pivot changing the dimension in the aggr function.
This is what I thought: I'm newer and perhaps there are severals better ways than mine. Any suggestion and ideas are really appreciated !!
Thanks for your time
Sorry, I don't understand, why don't you use getcurrentfield()?
I'm trying to explain that you can do what you want with one pivot using getcurrentfield() function within expression.
cyclic group My_group as dimension
=aggr(sum(salesamount), $(=getcurrentfield(My_group))) as expression.
The corresponding field name will be substituted in the expression.
Look at the screen provided above, there is cyclic group as dimension and expression with getcurrentfield().
You can see that the corresponding dimension value 'B' has been substituted instead of getcurrentfield().
Isn't it what you want ?