Grouping/ Bucketing Columns Together

[Asuod_]

Hello,

I have a wide table and I'm looking group certain columns together into three groups (Location, Personnel And Skills). For example, by selecting Location it will filter the table to only Location columns (Zip code, Address, City).

Columns: Zip Code, Address, City - Location

Columns: Job, Gender - Personnel

Columns: Sales Experience, Merchandising, Management - Skills

Any help on how to do this is appreciated. Thank you!

[Qrishna]

do you also have a fieldname called location, Personnel and Skills?

you could insert this piece in each respective group fields:

if(getselectedcount(Location)>=1, 1, 0) in the conditional show for all the three location fields. similarly do for others

[Asuod_]

I do not have a fieldname called Location, Personnel and Skills. Those are the groups im looking to create,  can you elaborate on the if(getselectedcount(Location)>=1, 1, 0) not sure how this would filter out everything besides the location fields.