I have this report that I run sometimes mid-month. People want to see some sections with daily data, in the mid-month report. i.e. if the report is run on the 18th Dec, then they want to see a table with 18 columns showing the MTD of the current month.
Also, it would be ideal to be able to have a comparable calculated field, i.e. same period but in the prior year.
I know I could easily go in to the report each time and change the dates, however key thing here is that the report must be dynamic as there are lots of them!
Anyone have a cool formula I could use?