Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to hide a pivot table or object Graphics?

hello! as I can hide an object or an object pivoting graphic design on my resume? and when you press a button, and make it show up again or pivot chart?

thanks

2 Replies
satishkurra
Specialist II
Specialist II

Hi

First Create a Variable from Variable Overview (CTRL+ALT+V) as vShowHide=1

Create Button -> General Tab -> specify Text as =if($(vShowHide)=1,'hide','show')  -> Actions Tab -> Select Action Type as External and Action as Set Variable -> Specify Variable as vShowHide and Value as =$(vShowHide)*-1  --> Now go to Pivot Table Chart Properties and in Layout Tab, Under Show, Specify Conditional Value as vShowHide=1 -> Click Apply -> Click OK.

Now come to button and click Show, Chart will be displayed and click once again the button, the text will be changed to hide and the chart will be hidden.

In this way, we can achieve this requirement with 1 button object ONLY.

Thanks

Satish

jagan
Luminary Alumni
Luminary Alumni