Hi to everyone!
I need to make a table where it is shown the YTD of Today AND the last 6 days. Something like this (if today it's May 20th):
|Day||YTD 2008||YTD 2009||YTD 2010|
I think it's a strange measure but... Does anyone how it could be done?
Thanks in advance for your time and dedication! And have a nice day!
If you always select a single date you could run a macro to extend the selection to include the previous 5 days.
Depending on the amount of data it might however be easier using the AsOfDate approach mentioned in other threads. With this you 6 fold your data in the load and have for each selected date the 6 records available for display.