YTD Issue

[mario-sarkis]

Please find attach file my sample date and my output

note that i used these two expressions :

1-current =(If(Month_Prod='YTD',RangeSum(Above(Sum({<Year_Prod={"$(=Year(Today()))"}>}Prod_AmountUSD),12-Month(Today())+1,$(vCurrMonth))),Sum({<Year_Prod={"$(=Year(Today()))"}>}Prod_AmountUSD)))/1000000

2-Previous=(If(Month_Prod='YTD',RangeSum(Above(Sum({<Year_Prod={"$(=Year(Today())-1)"}>}Prod_AmountUSD),12-Month(Today())+1,$(vCurrMonth))),Sum({<Year_Prod={"$(=Year(Today())-1)"}>}Prod_AmountUSD)))/1000000

and Dimenssion as "Month_Prod"

but i am getting wrong YTD Values hope you can help

i need to see the YTD of Previous Year in the same period of current year , if i am in sep-2015 need to see YTD calculated till sep-2014

[MK_QSL]

Check script and Bar Chart expressions from enclosed file..

[MK_QSL]

or 2nd option..