How to ignore filters for a certain column.

[former_member784354]

Hello, I have several columns that contain measurements. When I apply a Quarter filter, this measurements are aggregated by quarter. I have one column that contains constant value and should not be aggregated.

How can I achieve such behavior? Is it possible not to apply filters for the whole table?

[avsalynin]

ivan.karamyshev

yes, I agree with roy.jin , using content selection, you can exclude a number of measures from applying filters.

[roy_jin]

Hi Ivan,

You can disconnect an input control with a particular widget (chart or table) so the input control will not affect the widget. This can be done by configure the link analysis relationship for the input control via the 'more action'.

Please check it.

best regards, Roy

[former_member784354]

Hello Roy, thank you for the reply.

As I understand your solution affects the whole widget. But my question is about only one column. On the screenshot below column "J" and "K" contain measures which are summed up by quarter. Column "I" contains measure that illustates the weight of the product and must be constant regardless of filters. For example the weight of the product is 20, SAP Embedded Analytics counts the sum for the quarter which is 20*3=60. I need it t remain 20.

[roy_jin]

Hi Ivan,

In this case, you may try to use a restricted measure with constant selection.

Assuming you're using a dimension called DIM_A in your input control. In the definition of column I, you can assign the required member for this DIM_A dimension and enable the constant selection and set DIM_A as constant dimension.

best regards, Roy