Hi All / stalwar1,
I am facing some issue with on formula that is I have to create MoM chart with Growth for that I am using
Dim: = if(MonthEnd<Today(), MonthYear1 )
Expr:
for Sale :
fabs(Sum({<Year=, Quarter=, FiscalYear={">$(vFYM)"},[PostingDate]={">=$(=QuarterStart(min(PostingDate),4 ))<=$(=MonthStart(Today())))"}>} Amount))/100000
for Growth :
((Sum(Amount)-
above(Sum( Amount),12))/above(Sum(Amount),12)) * 100
VFYM:=Year(addyears(max([Posting Date]),-1))
using above in chart the data is coming properly But I want growth line I want to show from APR-15
Please find the attach
