Compare YTD versus PYTD showing sum based on current days in Month.

[#1]

In the attached example for the month of April I am trying to summarize 2010 versus 2011 by comparing the sum of the # days in 2011 versus the same amout of days in 2010.

[swuehl · Accepted solution]

Hi spb,

maybe like attached?

I just added a set for 2010 Date's:

Sum({<Year={"$(=Year(Max(Date))-1)"}, Date= {"<=$(=addmonths(max(Date),-12))"}>} Sales)

Hope this helps,

Stefan