Rewriting a formula so the source can run it
What you'll understand
- Move a calculation off the column so the data source can run the filter
- Rewrite the common traps: search boxes, blanks, dates, Not and an 'All' option
- Filter first and shape later, and know what With and AddColumns do to a query
Lessons are free. Sign in to read this one and keep track of the lessons you finish.