How to Show text object on click of any other object.

[#1]

Hi all  ,

i am stuck in a problem with UI design that i have two pivot tables on my sheet both are minimized so all i want is that on maximizing either of tables , a text box should appear on back of table so other object get hidden  and user can only see tables.

thank you

[sushil353]

Hi,

Simply use conditional hide option available in Layout tab of table property..

or you can also use autohide functionality.

Put some condition like if(variable=1,1,0)

HTH

Sushil

[amit_saini]

Ankit,

I would suggest here to link your object through button, See the attachment.

Thanks,
AS

[#4]

thnx amit and sushil,  But i dont  want to use button to show or hide my charts, all i want is this show or hide any object  when i maximize my table, i am using this expression  on my text object layout condition.

if(Count(GetActiveSheetId()='Document\CH64')>0,true(),false())

but it is not working out.