YTD Values

[#1]

Dear All,

I am having a scenario,that have to calculate YTD&MTD values in pivot table.

Ytd is nothing but cumulative values.And MTD values values belongs to current month.I am having data

from Apr 2009 to Sep 2009.Thing is when I click Jul 2009,in YTD I have to attain cumulative values of Apr 2009,May 2009,Jun 2009 and Jul 2009.That means,

YTD of Jul 2009->(Apr 2009+May 2009+Jun 2009+Jul 2009)

So if any one of you come across this kind of issue please help me out.It is very urgent.

Thanks&Regards

Jai

[#2]

Hi Jai,

have a look at the table "From Beginning of the year as example " .

Hope it helps to solve your problem.

Good luck!

Rainer