Regarding Filtering data

[rathnam_qv]

Hi all,

i have 3 straight Tables(ex:A,B,C).My requirement is

1. if i select any value from table A remaining B,C tables should get populate.

2.if i select any value from table B Only table C should get populate and

3. if i select any value from table C remaining A,B tables should get populate.

How to implement this.

can any one help me out.

Thanks in advance!!!

Regards,

Rathnam.

[tresesco]

May be, you can try showing charts conditionally. Condition could be something like: =GetSelectedCount(YourField)

[cfz]

Hi Rathman,

In the layout tab of the properties of the objects there is a show conditional section where you can add an expression reflecting your logic. Please post the qvw so we can give you a more specific answer.

Carlos

[rathnam_qv]

Hi Carlos Fernandez,

thanks for your reply.

PFA qvw and send me the solution.

Regards,

Rathnam.

[tresesco]

May be like attached. Check the expressions for each chart:

Layout tab->Show-> Conditional

[cfz]

Hi rathnam,

Please find attached your qvw modified.

I hope it helps.

Carlos

[rathnam_qv]

Hi Carlos,

Thanks for your precious time.

but i don't want to hide the charts.

Regards,

Rathnam.

[cfz]

Hi Rathnam.

Then instead of using the show conditional option you can put the logic on calculated dimension like

=if(GetSelectedCount(BUSINESS_UNIT)<>0,COST_CENTER_NAME)