4 Replies Latest reply: Jul 13, 2012 1:49 AM by gopinathmtech RSS

    Regarding Chart Set Analasis



      I am having Apr and May month wise MTD and YTD Actuals in chart. The Set analasis for YTD is "=Sum({<Year ={$(V_Max_Actual)},BudgetType_FCBUD=>}Amount/num(Denominator))".  Currently Data is comming for Selected Monthwise. I want display data like suppose user selected Apr and May., in may month YTD actuals i want add Apr month YTD data also. In same way if suppose user selected APR,May,June., in may month i want show apr + may and june month may+june YTD Actuals. For ref., see attachment. Kindly suggest set analasis for calculating YTD Actuals for previous month or some other script for YTD Actuals.