So I figured out one way to do it, it would seem that instead of the export data action there is a control component action that has a method export data that works with calculated columns and filters so that solves one problem. I am having a similar issue though in that I'm now trying to have a new calculated column that uses the values from a previously calculated column (similar to stacking excel formulas) but I can't figure out a way to access that data with something like currentRow.columnName I only have currentSourceRow which can only pull from the database.