How to create a button that will filter and show only specific columns of table.

[Zimm]

Below is a sample table. I would like to create a button that will filter to lets say only show columns B and E. I don't want any other columns to be shown when clicking this button besides B and E. Also, no rows should be filtered out either.

	A	B	C	D	E	F	G
S	2	2	0	0	1	3	1
T	2	3	1	3	0	3	3
U	2	2	5	1	0	3	5
V	5	5	2	3	0	3	1
W	2	2	0	5	0	2	2
X	3	3	0	1	0	5	1
Y	2	2	3	3	0	3	3
Z	1	1	0	3	5	2	0

Result looks like this after pressing button.

	B	E
S	2	1
T	3	0
U	2	0
V	5	0
W	2	0
X	3	0
Y	2	0
Z	1	5

Thank you for the help.

[ogster1974 · Accepted solution]

1. Create a variable to store the condition to show your columns. I have vShowColumns default value 1 and reduced columns 2.

2. Create 2 buttons one to set the variable condition to state 2 and another to return it to state one.

3. Create your table and add the following to your columns that will display under the "Show column If" condition.  Show showing under state 2 use =If($(vShowColumns)>=1,1,0) for showing under state one =If($(vShowColumns)=1,1,0)

End result

State vShowColumns=1 show all Sales breakdown

State vShowColumns=2 Show Total Sales only

[Zimm]

Thank you Ogster. Took me a bit to figure out all the steps but eventually got it. Worked perfectly.