Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have used a container in my sheet wherein there are 4 pivot tables. Out of 4 pivot tables I have used conditional column show in one of the pivot table which has been linked to a button. Upton clicking the button the column appears and disappears as required which has been working fine.
Now, my client tells me that its confusing for him to understand on which chart in the container the button works for. Currently, I have kept the button on the top of the container.
Now I need a way to either put the button inside the container with the same pivot table where it works or if I the button can be hidden/unhidden when that tab in the container is selected or if the button can be greyed out.
Kindly assist.
Thanks in advance!
you can nest container within another container, so each table has a container with both field selection and pivot
so structure as follow
CONTAINER
- SubContainer1 two rows /two columns
- - column 1, field selection button
- - column 2, pivot table
- SubContainer2 two rows /two columns
- - column 1, field selection button
- - column 2, pivot table
and so on
Hi @dushyant
I suggest you create 4 extra buttons to display each pivot table in that container.
in that 4 buttons 1 to display pivot with hidden columns and the button to show the hidden column.
The remaining 3 buttons show other pivot tables respectively.
so the hide and show button appear only along with that required table.
Hi Vineeth!
I tried adding a container into the existing container but, its not letting me do it. It seems that they have restricted some charts from adding into a container box.
Hi Dharanidharan!
I understood how I can create the b1 button but how can I link b2, b3 and b4 to the other normal tables such that, on clicking the button the tabs of the container change to their respective table.
Hi @dushyant Create a variable vChart (possible values 1 2)
use the action in buttons to set the variable
- first button set the variable 1, 2nd to 2 respectively
in chart properties of every chart use conditional show
- first chart: show only when vChart = 1
- 2nd when vChart = 2