Dynamic Columns?

I know columns cannot be recalculated so I'm wondering if there is a work around  I have a measure the calculates sum of sales at a given time (given time is based on users parameter selection) and...