Hide column with a button - BI7 / Excel2003

[Former Member]

Hi Experts,

I try to hide a column for give the choice to add and display elements on my table.

i want to put a button but i'm unable to configure it to hide my column.

Do you have ideas to help me?

Thanks, points for helpful anwers,

Adrien.

[manoj_kumar2 · Accepted solution]

Hi,

hide column can be done only from query designer using the option for the keyfigure->display and hide option.

I am not sure whether i understood your issue clearly

Do you want to configure a button in bex analyzer which should hide a column for you?

Rgds

Manoj Kumar

[Former Member · Accepted solution]

yes, finnaly, i have found the anwser myself.

it's just a macro in excel, and it's not a configuration in BI.

Sorry and thanks for your help !

Adrien