Ok, thanks for the screenshot.

So you have a pivot with COLUMN1, COLUMN2 in the rows, FY in columns and Amount is your measure.

Now you want to filter the rows of your pivot based on the total of Amount (all the FY summed together by COLUMN1 and COLUMN2).

And you said this is a "classic" analysis built on a dataset and not on a subject area, right?

You could set a filter based on an expression using the AGGREGATE( … AT …) function.

Your FY column is hopefully part of a dimension of some kind (a time dimension probably). There you should have a grand total level, if you do write the expression AGGREGATE( "Amount" AT "name of the dimension level above FY")you will get the Amount summed together for all the FY in your analysis. You can add a filter to your analysis based on that expression and it will only return rows where the sum of all the FY are above the amount you set.