Limit shown dimension values

[curiousfellow]

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 ?

[marcus_sommer]

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

[curiousfellow]

Both are numeric, so i suppose that can not be the reason

[tresesco]

If you could share your sample qvw, all this guessed suggetions could be avoided and could be hit the target directly.

[curiousfellow]

Trseco is right of course. So I herewith enclose an example

[tresesco]

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