1 Reply Latest reply: May 20, 2010 6:16 AM by juergm RSS

    Table with the YTD of each of the last 6 days

      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):

      DayYTD 2008YTD 2009YTD 2010
      14/05/1037119,3005839264,685638609,41248
      15/05/1037241,1106740060,6485839130,12005
      16/05/1038099,8027640724,0034739717,98139
      17/05/1038969,270840981,2921639717,8849
      18/05/1039607,4329540975,4904640016,3969
      19/05/1039749,9028741220,6416640585,95065
      20/05/1040153,9854843109,2508640585,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

        • Table with the YTD of each of the last 6 days
          juergm

          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