Filter excel table with formulas

I'm trying to filter a data table in Excel but the values I'm filtering are products of a formula. I've found that that the output from my SQL filter produces blank values for any cells with a formula, is there a way to retrieve the values for these cells?