How hide and show pivot table

[Anonymous]

Hi Community,

I have created two pivot table 'Test1','Test2' .

I have one List box in that there two field 'Test1' , 'Test2'.

When i click on List box Field 'Test1' that time hide pivot table 'Test2' and show pivot table 'Test1' and

when i click on List box Field 'Test2' that time hide pivot table 'Test1' and show pivot table 'Test2'.

How i can achive this hide and show condition?

Thanks in advance

[sunny_talwar · Accepted solution]

Would you ever want to select both and see both at the same time? or is it always one or the other? May be use these conditions if it is always one or the other:

Pivot Table Test1

=FieldName = 'Test1'

Pivot Table Test 2

=FieldName = 'Test2'

[Anonymous]

Hi Sunny

Thanks for your quick reply i always want to show only one pivot table.

and i have already used this solution that means i have already written this logic in pivot table layout >>Show >> conditional  box but it is not worked.

can you share with me test QVW. 

[sunny_talwar]

I think it might be best if you can share what you have

[Anonymous]

Hi Sunny,

Please refer attached file.

In QVW i have used logic in both pivot table.But when i click class A field both table hide i want only show Pivot table T1 and when i click on class B field i want to show only pivot table T2.

I have used same logic in my server application but it is not work.

is any setting i have to do for this?

[sunny_talwar]

You forgot the single quotes

=Class='B'

=Class='A'

[Anonymous]

Hi Sunny,

Your logic working properly.

Thanks for you help