Hide Columns validating a condition through groovy

Summary:

I would like to validate a condition of row member and hide columns which does not satisfy that condition.

Content (required):

Looking for a groovy logic to see if its possible to achieve for a given scenario below

I have accounts as rows and period, year on columns , say an account getValue which has formula to calculate or display an intersection value, if this value is missing then hide entire column if not show the column, is it possible to achieve this through groovy.

Version (include the version you are using, if applicable):

23.01.31

Code Snippet (add any code snippets that support your topic, if applicable):