Bex Query : Dynamically removing columns having NULL data
I have 4 columns(characteristics) in my report .Of which at any time some of these charactersitcs could be empty(or NULL). Then I would like to drop those columns (characteristics) from my report.
Column1 , Column2 Column3 Column4
Peter , India , , 190
John , Germany , , 1909
I would like to drop Column3 from my report. But based on the filter criteria it could be possible that Column3 is filled in but Column2 is null . So in that case I intend to drop Column2.
Is this possible & how?
Zero Suppression should be able to hide the columns if you have it turned on for both rows and columns.