Multiple Selector with Calculated Dimension not showing field in green

[microwin88x]

Hello!

I have a calendar (from xxx date / to xxx date) and multiple selection fields:

The multiple selection fields (for example: Zona, Partido, Localidad, Oficina) are a calculated dimension

Example for Oficina: =IF(ID_TIE_FECHA# >= '$(vFechaDesde)' AND ID_TIE_FECHA# <= '$(vFechaHasta)',OFICINA)

>>> That is to use the calendar when I select dates.

The thing is that when I select a value IN A CHART (or somewhere outside the multiple selector) it doesn't selects in green in the multiple selector, as you can see in the following image:

I believe it has to be with the calculated dimension defined in the multiple selector. Is there any way to automatically select the corresponding value?

Thank you!!!

[Nicole-Smith · Accepted solution]

Try changing your dimension to:

aggr(only({<ID_TIE_FECHA#={'>=$(vFechaDesde)<=$(vFechaHasta)'}>}OFICINA),OFICINA)

[microwin88x]

Thank you!!! It worked!!