15 Replies Latest reply: Nov 9, 2010 11:22 AM by Wouter Hollander RSS

    Finding YTD Values

      Dear All,

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

      Ytd is nothing but cummltive values.And MTD values values belongs to current month.Iam having data

      from Apr 2009 to Sep 2009.Thing is when I clik Jul 2009,in YTD I have to attain cummltive 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