Regarding Chart Set Analasis

[#1]

Hi,

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.

[#2]

use this

Sum({<Year ={$(V_Max_Actual)},BudgetType_FCBUD=,Month=>}Amount/num(Denominator)

[#3]

Hi,

Thanks for u r answer.  While i am adding Month my YTD Actuals is coming all 0.00.

[#4]

Hi,

Thanks for u r answer.  While i am adding Month my YTD Actuals is coming all 0.00.

[#5]

Hi,

Thanks for u r answer.  While i am adding Month my YTD Actuals is coming all 0.00.