Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Trying to make pivot table using two dimentions by X and by Y, but want to use same field in basic and alter state.
Basic state is simple, i just add dimention.
Alter state is: =AGGR(ONLY({AS1} MyDimention),MyDimention)
but when i select something at basic state it limits AS1 too, because it used at AGGR without alter state condition.
how can i make second dimention not limited by basic state selections?
Hi.
The problem could be in the expression.
Hi,
Can u pls share the sample app?
Thanks !!