3 Replies Latest reply: Mar 29, 2013 2:43 AM by Kiran V RSS

    Help on Accumulation

      Hi Everyone,

       

      I would like some assistance on the issue that I'm facing with a report. I am using pivot table object to display accumulated values for the selected quarter and year, the previous quarter and same quarter for the year before. The data starts from year 2010 till 2012 but only the values from year 2010 seems correct and the rest of the years and quarter seems wrong.

       

      The code that i use for current quarter is as below:

       

      Sum({$<PostingYear={"<=$(=Max(PostingYear))"},PQuarter={"<=$(=Max(PQuarter))"},PostingQuarter=>}Amount/1000)

       

       

      I would like to know if there any better way to achieve this.

       

      Thank you.

       

      Regards,

      Vivek