Table with the YTD of each of the last 6 days

[#1]

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
14/05/10	37119,30058	39264,6856	38609,41248
15/05/10	37241,11067	40060,64858	39130,12005
16/05/10	38099,80276	40724,00347	39717,98139
17/05/10	38969,2708	40981,29216	39717,8849
18/05/10	39607,43295	40975,49046	40016,3969
19/05/10	39749,90287	41220,64166	40585,95065
20/05/10	40153,98548	43109,25086	40585,95065

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!

Josep

[#2]

Hi

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.

Regards

Juerg