Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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