How to hide column in BEx Analyzer

[Former Member]

Hi gurus

In my report I have to show 5 columns depending on a condition.

Is it feasible?

Regards

[Former Member]

Hi,

You can use VBA Macro to execute Code to hide the columns based on the condition.

This is in 3.5

Sub SAPBEXonRefresh(queryID As String, resultArea As Range)
           'Check you condition 
           If <condition> Then
                   'This will hide Column 3 on Sheet1 where the Query is. 
                   ThisWorkbook.Sheets("Sheet1").Columns(3).Hidden = True 
           End If               
End Sub