The best way to do this depends very much on how you want the View to behave.

However,
Code:
=IF(FILTERNAME()="Hide Column","",{Value})

and then giving the column the attribute to AutoHide is a simple approach. A column with the AutoHide attribute will be hidden if it contains all zeros or spaces.
_________________________
Andrew Bates