How to hide columns from Intractive Grid Oracle Apex

I need to know How to hide columns from Intractive Grid Oracle Apex, for example

I have select list value as x,y,z

:P_SELECT_LIST

If :P_SELECT_LIST is x then show all the columns like name,email,number , if :P_SELECT_LIST is y then show only name column and same for z show only name column

Each column has a setting called "Server-side Condition".

For your example I would use

• Type: "Function Body"
• Language: "PL/SQL"
• PL/SQL Function Body:

    if :P_SELECT_LIST = 'X' or :P_SELECT_LIST = 'Y' THEN
       return true;
    else
       return false;
    end if;

Set this for each column according to your needs.

If you want this to change after selecting something in the :P_SELECT_LIST item you need to set "Page Action on Selection" to "Submit Page" in the Settings of the item :P_SELECT_LIST.