Ignore Selection in Dimension using filter pane

[kavirao]

Hi

Need suggestions. 

I have 2 filter panes One for State and another for Cities.  Both the filter pane is allowed to select only one value.

State	City
NJ	ABC
NJ	XYZ
PA	RRR
PA	YYY
NJ	EEE
PA	TTT

1. Both State and  City filter pane placed in Tabbed Container. 
2. Both fields State and City enabled select only one value in field properties.   
3. Either one of table is visible to user. 

• On select  of State Filter pane should not change city filter pane.   It has to list all cities ignoring selection of state.
• If I select  City corresponding State needs to be changed in State, as One value field property enable in STATE.

On based on the selection I have  20 Charts will be displayed in the sheet.  I cannot perform using Alternate State option.

Please provide suggestions to implement this.

Kavitha

[Digvijay_Singh]

It looks quite complex and looks contradicting when you want to ignore selection in the city filter pane but city has always one selected value checked.

Wanted to try something like Aggr(only({<State=>}City),City) in the City filter pane but select only one value make things difficult.

Hope other community experts will be able to help.

[Digvijay_Singh]

Missed'1' to show all values,  Aggr(only({1<State=>}City),City), but I know it won't help though to achieve the expected..

[kavirao]

thank for response, yes require better solution it doesn't work as expected.

Let  see if anyone had faced this kind of requirement. 

[valishaik1985]

Hi Digvijay,

I am also facing same kind of issue, my filter pane selected always only one value other values not displaying. clear all selections then select another and only one at a time .

Is there any possibility to make multiple selections? 

In my calculated dimension used something like IF(Aggr(Count( value), function)>0, function).

Regards,

Khasim