Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to remove a specific value from a dimension filter after the selection.
For example: DIM OFFICE = (LONDON,PARIS,ROME)
If I select LONDON in the filter, this value will be excluded from the report in which there's that dimension.
Thank you
May be you can try with Field Event Trigger. Like
Settings -> Document Properties -> Triggers -> Field Event Triggers ->
Select your Field (DIM OFFICE ) -> On Select -> Add Actions -> Select Excluded -> Give your Field
Or , in the Chart Expression
=Sum({<[DIM OFFICE]=e([DIM OFFICE])>}Measure)