dimenssion with no efect

[Anonymous]

hi,

i have deshboard and i want that 2 of the chart will no efect from dimenssion select ( month ),

it will show from first month till today , but the others objects will efected by the month selection.

hope it's understood.

thanks'

yarin.

[eduardo_sommer]

Hi,

If you don't want that a selection influence a chart expression, you can do this using set analysis, as in sum(${<month=> value). This syntax will ignore any selection in the field month.

Eduardo

[SergeyMak · Accepted solution]

small correction:

sum(${<month=>} value)

[senpradip007]

Try this:

Sum({$<Month=, [Other Fimensions]>} [Your field])

or

Sum({$<Month, [Other Fimensions]>}  [Your field])

[jagan]

Hi,

If you want to ignore the selections then you can just give MonthDimensionName= in set analysis expression, it ignores the selection of the field.

Ex: sum(${<MonthDimensionName=>} MeasureName)

Replace MonthDimensionName and MeasureName with your actual field names.

Regards,

Jagan.