How apply background De-active filter using Dimension Filter ?

[chandrasekhar6]

Hi Experts,

Suppose I have a single data source name DS_1 and I applied DS_1 source to both chart and Crosstab as below,

When I selecting Year filter from Dimention filter only chart changed depends on year and crosstab don't change.

How to De-filtering to crosstab component.

thanks,

Sekhar

[TammyPowlas]

I am not following and I cannot recreate this issue

Are you saying you filter only the chart filters, and not the cross tab? The numbers for California look the same to me.

Please also clarify, and share version of Design Studio

[MustafaBensan]

Hi Sekhar,

If your requirement is that you only want to apply the Year filter to the chart and not the crosstab as well, then you will need to duplicate the data source and assign the copy to the crosstab. The Dimension Filter should then only target the first data source which is assigned only to the chart.

Regards,

Mustafa.

[chandrasekhar6]

Hi Mustafa,

Thanks for suggestion.

I used duplicate Data source then application loading is very slow.

Thanks,

sekhar

[MustafaBensan]

Hi Sekhar,

Yes, unfortunately duplicating the data source will impact performance. However, I can't think of an alternative, more efficient approach to achieving your requirement. Is there a reason why the Year filter should only apply to the chart and not the crosstab? It would seem to me that for consistency of comparing the chart to the crosstab data, the Year filter should be applied to both.

Regards,

Mustafa.