Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a listbox in which I select a period.
In a pivot table all periods less than or equal than the selected period are presented as a dimension.
When I use the next formula as a calculated dimension I don't get what i want :
if(period < $(chosen_period),period)
Is it possible to limit the dimensions with a formula ?
This approach is possible - I think in your case is either the field or the variable or both not numeric and then an operator like <>= will fail.
- Marcus
Both are numeric, so i suppose that can not be the reason
If you could share your sample qvw, all this guessed suggetions could be avoided and could be hit the target directly.
Trseco is right of course. So I herewith enclose an example
Rather use set analysis in the expression to limit the values in dimension. Let the second dimension be: periode and try expression:
=sum({<periodkeuze=,periode={'<$(gekozen_periode)'}>}value)
PFA