How apply background De-active filter using Dimension Filter ?

[TammyPowlas]

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

[Former Member]

Hi,

Yes the year object have to be in rows are columns to use it in data selection.

But we can customize the crosstab using css to show only result of year right. Sorry if i confused you in my previous answer I have added my complete answer with screen shot

We can have initial view of data as in above image.

Then we can hide the columns not needed in crosstab and use data selection in chart.

The CSS i used to hide columns in my crosstad is

.sapzencrosstab-DataArea tbody tr td:NTH-CHILD(1), .sapzencrosstab-DataArea tbody tr td:NTH-CHILD(2),

.sapzencrosstab-DataArea tbody tr td:NTH-CHILD(3), .sapzencrosstab-DataArea tbody tr td:NTH-CHILD(4),

.sapzencrosstab-DataArea tbody tr td:NTH-CHILD(5), .sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(2),

.sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(3), .sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(4), .sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(5), .sapzencrosstab-ColumnHeaderArea tbody tr td:NTH-CHILD(1)

{ display: none !important; }

Let me know if anything need in it.

Thanks,

Poovarasan