Calendar "Compare Dates" Option Should be More Flexible



When looking at a single date range, using 7/11/2010 - 7/17/2010, I don't like that when I then select to "Compare Dates" and select the week prior (7/4/2010 - 7/10/2010), the "Change" column does the calculation based on OLD minus NEW (i.e. week ending 7/10/2010 minus week ending 7/17/2010 - see attachment).  The only way to get around this is to move the order of the date ranges to pull the old dates first; however, this doesn't seem like a great solution, since the report then shows the older data next to the prop/evar values.

It would be great if the "Change" column would calculate based on the left column of data minus the right column of data.

2 Comments (2 New)



I always missing the option compare last week with the week before or last month with the month before. Or compare last month with the same month of last year.



I fully support this. This has been an issue for years now and provokes question marks all around the organisation. I cannot believe so few people have a problem with this.